Saving long date format - InfoPath Dev
in

InfoPath Dev

Saving long date format

Last post 10-05-2010 05:23 AM by Jimmy. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 10-05-2010 03:02 AM

    Saving long date format

    Hi,

     I know the today() and now() functions write out the date/time fields in this format - YYYY-MM-DDThh:mm:ss

     I've used the substring function of those to just give me the YYYY-MM-DD but I'd like this to be saved in long format in the variable, in the same way the display can be changed to DD Month Year - is this possible at all?

    Thanks,

    Jason.

  • 10-05-2010 04:55 AM In reply to

    Re: Saving long date format

    By Month and Year, do you mean representing 2010-10-05 as 05 October Two Thousand Ten?  Or is your Year the same as YYYY.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 10-05-2010 05:04 AM In reply to

    Re: Saving long date format

    Thanks Jimmy - I guess I made a mistake there of explaining it properly. I meant for it to represent as 5 October 2010.

    I just found this article that appears to do what I need - if this is the best solution?

     http://www.bizsupportonline.net/infopath2007/how-to-extract-month-name-from-date-picker-infopath.htm

     

    Jason.

  • 10-05-2010 05:23 AM In reply to

    Re: Saving long date format

    Yeah, that's pretty much how I would have suggested you do it.  Add a secondary data source with the month names and use that for grabbing the name for any month number.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.