Calculated Field to convert Date

[RobinTMavhu]

The screenshot below refers, l want to create a Calculated Field to convert the column EFFDATE into a proper date format. Current format is 04/03/2024 07;06:22 which is a string and not proper date format for trend analysis.

[Clement15]

Hello, would you like this field to be understood as a date field? This function in the script should work :

Timestamp(Timestamp#(EFFDATE,'DD/MM/YYYY hh:mm:ss')) as EFFDATE

[RobinTMavhu]

Hi Clement

Yes however "as" is not being recognized

[Clement15]

The function I gave you is to put the script in place of your current field, in the data load editor.

[Clement15]

I don't use the data manager, but I guess you just have to remove the last part ''as EFFDATE''

[RobinTMavhu]

Thanks Clement

I am very new to Qlik and struggling which line do l really replace or i do it in the auto generated section

[Clement15]

If you only use the data manager, try this formula in a Calculated Field
Timestamp(Timestamp#(EFFDATE,'DD/MM/YYYY hh:mm:ss'))

If you are just starting out, the data manager is useful, but to progress and open up possibilities, I advise you to learn how to use the data load editor.

[RobinTMavhu]

Thank you, it's giving blank values

[Clement15 · Accepted solution]

And like this ?

Timestamp(Timestamp#(EFFDATE,'DD/MM/YYYY hh;mm:ss'))

[RobinTMavhu]

Thank you so much, problem solved!!