Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have a question. My date column format = Jan 1, 2023 3:45:53 PM
how can i convert = 'dd.mm.yyyy hh24:mi' on qlik set expression for data upload.
Before, i tried to some methods but i could not be succefful.
date(num(date#("LagDuration Timestamp",'DD.MM.YYYY')),'DD.MM.YYYY') as date3
date ("LagDuration Timestamp", 'mmm d,yyyy hh:mm:ss AM/PM') as date2
Thank you.
try,
timestamp(timestamp#('Jan 1, 2023 3:45:53 PM','MMM D, YYYY h:mm:ss TT'),'DD.MM.YYYY hh:mm')
Regards,
Prashant Sangle