Newbie Questions

Re: How to convert "number" to "name" of month by function.

adamrharding — Tue, 09 Oct 2007 09:57:25 GMT

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

Cheers Adam

Re: How to convert "number" to "name" of month by function.

jatuphum — Mon, 08 Oct 2007 03:25:23 GMT

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

Re: How to convert "number" to "name" of month by function.

Clay Fox — Fri, 05 Oct 2007 18:38:20 GMT

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.

How to convert "number" to "name" of month by function.

jatuphum — Fri, 05 Oct 2007 10:57:01 GMT

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.