topic Time format in App Development

Time format

EvanBarrick — Thu, 13 Dec 2018 20:15:54 GMT

I have a field 'TIME' that comes in formatted as 7:00:00 PM, however displays as 19:00:00 PM.

How can I correct this?

Ivan_Bozov — Thu, 13 Dec 2018 20:52:51 GMT

Hi! In your Main script section:

SET TimestampFormat='DD.MM.YYYY h:mm:ss[.fff]';

EvanBarrick — Thu, 13 Dec 2018 20:55:43 GMT

I deleted the 'TT' from the main tab, same result

Ivan_Bozov — Fri, 14 Dec 2018 07:38:20 GMT

What 'TT'?

hh:mm:ss - 24 hours
h:mm:ss - 12 hours

🙂

EvanBarrick — Thu, 13 Dec 2018 21:19:41 GMT

Cannot get this to function correctly

zebhashmi — Thu, 13 Dec 2018 22:01:46 GMT

If you just want to change the format of the Feild you can do that in load.

Date(Date#([yourfeild], "YY-MM-DD H:M:S" ), "hh:mm:ss " ) as yourfeild

Ivan_Bozov — Fri, 14 Dec 2018 08:06:51 GMT

EvanBarrick — Fri, 14 Dec 2018 16:13:45 GMT

ID	MONTH	DAY	Date	YEAR	TIME
1	Oct	4	10/4/18	2018	7:00:00 PM

EvanBarrick — Fri, 14 Dec 2018 16:18:42 GMT

Timestamp(TIME, 'h.mm TT') in my sheet object functioned correctly.

Thank you for the help