Is it possible to extact year from date picker into textbox ? - InfoPath Dev
in

InfoPath Dev

Is it possible to extact year from date picker into textbox ?

Last post 06-23-2017 12:56 AM by kokosz008. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 06-21-2017 02:08 AM

    Is it possible to extact year from date picker into textbox ?

    Hello,

     

     I would like to know,

     Is it possible to extact year from date picker into textbox ?

     Thank you very much for your help,


    Adam

    Filed under:
  • 06-21-2017 08:10 AM In reply to

    Re: Is it possible to extact year from date picker into textbox ?

     You bet. The default formula for the field bound to the textbox would be:

    substring-before(fieldwithdate, "-")

    XML stores dates in yyyy-MM-dd format. The date picker or other control may display the date differently, but if you open an XML file saved from your form and look at the date field, it will be yyyy-MM-dd. If it includes time, it will be yyyy-MM-ddTHH:mm:ss 

    Hilary Stoupa

  • 06-23-2017 12:56 AM In reply to

    Re: Is it possible to extact year from date picker into textbox ?

    Thank you :)

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.