Newbie Questions

Re: Saving long date format

Jimmy — Tue, 05 Oct 2010 12:23:39 GMT

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.

Re: Saving long date format

cheason — Tue, 05 Oct 2010 12:04:19 GMT

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.

Re: Saving long date format

Jimmy — Tue, 05 Oct 2010 11:55:31 GMT

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.

Saving long date format

cheason — Tue, 05 Oct 2010 10:02:33 GMT

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.