topic Re: converting timestamp to date in App Development

converting timestamp to date

Lalitha — Mon, 28 Jun 2021 06:32:45 GMT

Hi,

I have a timestamp like this: 2021-03-23 19:16:08.1010000 +00:00

Please help how to convert the above timestamp to the Date filed - 'MM/DD/YYYY' format.

Thanks in advance..!

NitinK7 — Mon, 28 Jun 2021 10:33:13 GMT

may be

Date(Date#(Subfield(Date filed,' ',1),'YYYY-MM-DD'),'MM/DD/YYYY')

Lalitha — Mon, 28 Jun 2021 12:57:42 GMT

Hi Nitin,

Thanks for you reply, I tried this but it’s not working.

NitinK7 — Mon, 28 Jun 2021 14:01:18 GMT

could you please attach here your sample data for this field?

NitinK7 — Mon, 28 Jun 2021 14:01:22 GMT

could you please attach here your sample data for this field?