Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
EvanBarrick
Creator
Creator

Time format

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?

1 Solution

Accepted Solutions
Ivan_Bozov
Luminary
Luminary

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...
vizmind.eu

View solution in original post

8 Replies
Ivan_Bozov
Luminary
Luminary

Hi! In your Main script section:

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

 

 

vizmind.eu
EvanBarrick
Creator
Creator
Author

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

Ivan_Bozov
Luminary
Luminary

What 'TT'?

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

🙂

vizmind.eu
EvanBarrick
Creator
Creator
Author

Cannot get this to function correctly

zebhashmi
Specialist
Specialist

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
Luminary
Luminary

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...
vizmind.eu
EvanBarrick
Creator
Creator
Author

IDMONTHDAYDateYEARTIME
1Oct410/4/1820187:00:00 PM
EvanBarrick
Creator
Creator
Author

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

 

Thank you for the help