Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi! In your Main script section:
SET TimestampFormat='DD.MM.YYYY h:mm:ss[.fff]';
I deleted the 'TT' from the main tab, same result
What 'TT'?
hh:mm:ss - 24 hours
h:mm:ss - 12 hours
🙂
Cannot get this to function correctly
If you just want to change the format of the Feild you can do that in load.
like
Date(Date#([yourfeild], "YY-MM-DD H:M:S" ), "hh:mm:ss " ) as yourfeild
ID | MONTH | DAY | Date | YEAR | TIME |
1 | Oct | 4 | 10/4/18 | 2018 | 7:00:00 PM |
Timestamp(TIME, 'h.mm TT') in my sheet object functioned correctly.
Thank you for the help