Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sagar082
Creator
Creator

Convert date time field to timestamp

Hi folks,

Greeting for the day. I have a column which contains date and time in following format;

'24-AUG-21 12:00:00.4660000 AM'

It has string data type.

The desire format is;

24/08/2021 00:00:00

Should have data type timestamp.

12 Replies
PrashantSangle

is it possible for you to share an app? or share snip of script?

 

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 🙂
Sagar082
Creator
Creator
Author

Hi, Akshat

I believe you are writing the formula in analysis window whereas I was trying it in load window.

akshatagrawal
Partner - Contributor III
Partner - Contributor III

Hi Sagar,

I have tried it both the ways, data load editor as well as chart expression.

It's working fine. Please find attached screenshots.

akshatagrawal_0-1633330951742.pngakshatagrawal_1-1633330979220.png