General

Re: Formating Date in a text field that is a string

traveladic — Tue, 10 Jan 2012 21:23:46 GMT

That worked perfectly

thank you very much

Re: Formating Date in a text field that is a string

Anson Hidajat — Tue, 10 Jan 2012 17:49:39 GMT

Try pasting this as your formula:

concat(msxsl:format-date(now(), "dd-MMM-yyyy"), msxsl:format-time(now(), " hh:mmtt"))

Hope that works for you!

Formating Date in a text field that is a string

traveladic — Tue, 10 Jan 2012 15:48:01 GMT

I have a form that some time requires the submition of hardcopies in specific cases and we need to track when we recieve those hardcopies.

The problem I am having is that when the hardcopies aren't required, that same field need to contain N/A which mean that the field need to be set as a string but when I set it as a string the now() information comes out as "2012-01-10T08:34:54" and I need it to read as "10-Jan-2012 08:34am".

any though on how to resolve this?

Thanks you,