how can i convert timestamp date field to understandable format for qlik

[mustafakuloglu]

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.

[PrashantSangle]

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