Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

carlos13
Contributor

Converter military time to standard time

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

Any ideas?,

thanks

6 Replies
Not applicable

Re: Converter military time to standard time

Time(Date) as Date

is it?

rustyfishbones
Honored Contributor II

Re: Converter military time to standard time

Can you share some sample data?

carlos13
Contributor

Re: Converter military time to standard time

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

rustyfishbones
Honored Contributor II

Re: Converter military time to standard time

So just subtract 12

mov
Esteemed Contributor III

Re: Converter military time to standard time

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
Honored Contributor II

Re: Converter military time to standard time

Thanks Micheal,

makes sense, so TT is for Terrestrial Time

Community Browser