Newbie Questions

Re: set date and time to display in mm/dd/yyyy hh:mm:ss AM/PM format in textbox

Jimmy — Thu, 05 Jan 2012 06:16:37 GMT

Well, this is the formula I came up with based on your original question:

concat(substring(field1, 6, 2), "/", substring(field1, 9, 2), "/", substring(field1, 1, 4), " ", substring("0", 1, substring(field2, 1, 2) mod 12 + 12 * (substring(field2, 1, 2) mod 12 = 0) < 10), substring(field2, 1, 2) mod 12 + 12 * (substring(field2, 1, 2) mod 12 = 0), substring(field2, 3, 6), " ", substring("AP", 1 + (substring(field2, 1, 2) >= 12), 1), "M")

Why can't you change the data type of the field?

Re: set date and time to display in mm/dd/yyyy hh:mm:ss AM/PM format in textbox

venkatzeus — Thu, 05 Jan 2012 04:41:14 GMT

Hi,

Thank you very much for the reply.

Data type of the textbox is text(string)

Could you please provide the format code for using with now() to show in mm/dd/yyyy hh:mm:ss AM/PM format.

Thank you

Re: set date and time to display in mm/dd/yyyy hh:mm:ss AM/PM format in textbox

Jimmy — Wed, 04 Jan 2012 16:19:20 GMT

Why not just have the default value as now(), and use the formatting options to display it the way you want it?

Re: set date and time to display in mm/dd/yyyy hh:mm:ss AM/PM format in textbox

venkatzeus — Wed, 04 Jan 2012 16:08:12 GMT

Hi,

Tried like this:

concat(substring(xdDate:Today(), 6, 2), "/", substring(xdDate:Today(), 9, 2), "/", substring(xdDate:Today(), 1, 4), " ", substring-after(xdDate:Now(), "T"))

and it is giving result.

However, AM/PM is not shown.. Is it possible to add the AM/PM with the above formula.

Thank you

Re: set date and time to display in mm/dd/yyyy hh:mm:ss AM/PM format in textbox

Jimmy — Wed, 04 Jan 2012 15:57:32 GMT

Simply change the formula to:

concat(field1, 'T', field2)

Then you can use the formatting options to show it the way you like.

set date and time to display in mm/dd/yyyy hh:mm:ss AM/PM format in textbox

venkatzeus — Wed, 04 Jan 2012 15:18:37 GMT

Hi,

I have added 3 textboxes.

one having date only. Another having time only.

In the third textbox, i would like to have the concatenated value.

First textbox - Data type as Date - shows result as : 01/04/2012

Second textbox - Data type as Time - shows result as : 06:57:11 AM ( i used this formula: substring-after(now(), "T") )

Third textbox - Data type as Text(string). I have added the rule for concatenating as : concat(field1, field2)

However the Third textbox is displaying result as : 2012-01-0406:57:11

I need to show in the third textbox as : 01/04/2012 06:57:11 AM

How to achieve this?

Thank you