Time format

[EvanBarrick]

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]

Hi! In your Main script section:

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

[EvanBarrick]

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

[Ivan_Bozov]

What 'TT'?

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

🙂

[EvanBarrick]

Cannot get this to function correctly

[zebhashmi]

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

[Ivan_Bozov · Accepted solution]

Try the TimeStamp function and maybe give us a sample of your data so we can check.

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/Formatting...

[EvanBarrick]

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

[EvanBarrick]

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

Thank you for the help