InfoPath Dev

Hi,

I want to convert "string number" to "name" of month.

concat(substring(now(), 9, 2), " ", substring(now(), 6, 2), " ", substring(now(), 1, 4), " ", substring-after(now(), "T"))

This code that I use for convert date and time to my datetime format. But the only thing that I can't to do is "convert number to name of month". (In green content)

How should I do for solve this solution?

Thank you very much.

Have you looked at field formating?  With an expression or field you can set the way a date is displayed and the month in text is one of the options.

You can create a field which is a date and time field, set the default as Now() and then set the formatiing so that is displays the way you want without a formula and doing it manually.

I look at defualt format that Infopath provide. But I cannot found format that I want. So I use concat function. 

Can I set format "1 January 07 16:40:39" ?

Thank you very much

Hi

Using formatting I can display the date and time as 1 January 2007 16:40:39 would this be good enough?

Cheers Adam