Convert date time field to timestamp - Page 2 - Qlik Community

Sagar082 · ‎2021-09-28

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.

PrashantSangle · ‎2021-10-04

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 · ‎2021-10-04

Hi, Akshat

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

akshatagrawal · ‎2021-10-04

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.