Solved: string to time(hh:mm) - Qlik Community

Report Inappropriate Content · ‎2012-10-10

Hi-I have a string field which looks like 20120927-00:00:01.Can you please let me know how can I extract only HH:MM.Thanks-Pooja

Gysbert_Wassenaar · ‎2012-10-10

I think this should work: time(time#('20120927-00:00:01','yyyyMMdd-hh:mm:ss'),'hh:mm')

talk is cheap, supply exceeds demand

Gysbert_Wassenaar · ‎2012-10-10

I think this should work: time(time#('20120927-00:00:01','yyyyMMdd-hh:mm:ss'),'hh:mm')

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2012-10-10

Thanks a lot for your quick response.