Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

zagzebski
Contributor

Time format of hours/minutes from date stamp (GMT time)

I have a field TIMESTAMP that is in the in the following format as an example : 11/15/2005 4:30:00 PM

I need to convert this time which is in GMT to Central Standard Time in just hours minutes ( 16:30 as an example)

Thanks in advance,

Steve

Tags (2)
1 Reply
MVP
MVP

Re: Time format of hours/minutes from date stamp (GMT time)

I think with ConvertTo...., see online help

=time(frac(ConvertToLocalTime(date#('11/15/2005 4:30:00 PM', 'MM/DD/YYYY hh:mm:ss tt'), 'Fuso centrale (USA e Canada)') ),'hh:mm')

adapt bold to your pc

Community Browser