Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
carlos13
Creator
Creator

Converter military time to standard time

can convert the 14 hour military to 2 a.m EST?

Any ideas?,

thanks

6 Replies
Not applicable

Time(Date) as Date

is it?

rustyfishbones
Master II
Master II

Can you share some sample data?

carlos13
Creator
Creator
Author

but if what I have is the value 14 in number, I can pass it to standard time?

rustyfishbones
Master II
Master II

So just subtract 12

Anonymous
Not applicable

Carlos,

You simply define the time format as TT:

timestamp(YourTimeField, 'hh:mm TT')

For example,

=timestamp('14:00:00', 'hh:mm: TT')

returns 2:00 PM

Regards,

Michael

rustyfishbones
Master II
Master II

Thanks Micheal,

makes sense, so TT is for Terrestrial Time