Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-09-30 03:05 PM

Anyone knowns what function to change a time?

I have a data with 9:00 AM and 9:00 PM, and i need instead of 9:00 PM, 21:00.

Anyone knowns what function i need to solve this??

Tks a lot!!!

271 Views
0 Likes
1 Reply
pover
Partner - Master
Partner - Master
‎2010-09-30 03:10 PM

If the time 9:00 AM is text, it would be time(time#(Field, 'h:mm tt'),'H:mm') and 9:00 AM is already considered time in QlikView it would be time(Field,'H:mm').

Regards.

243 Views
0 Likes