Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mustafakuloglu
Contributor
Contributor

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

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.

Labels (5)
1 Reply
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

 

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂