Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ferha_jafri
Partner - Creator III
Partner - Creator III

how to convert system time to hr

Hello Everyone,

I am facing a problem in converting system time to hours , I tried

time(time#(Now(),'DD/MM/YYYY hh:mm:ss'),'hh') but I am getting the time in hh:mm:ss although I want hours only.Not sure what I am doing wrong.

Thank you

Regards

Ferha

3 Replies
sasiparupudi1
Master III
Master III

Time(Now(1),'hh')

Not applicable

time(now(),'hh')

puttemans
Specialist
Specialist

Hi,

How about Hour('DD/MM/YYYY hh:mm:ss') ?

Regards,

Johan