Date Conversion

[RobinTMavhu]

SOS. How can l can convert a date showing as 20240228140000 (yyyymmddhh24miss) into a proper date that can be interpreted by Qlik as a dimension in years, month, week and day. It is currently being interpreted as a string.

[Clement15 · Accepted solution]

Hello, here's what you can do

[RobinTMavhu]

How can l convert it using the calculated field option? my data set has date column in that form which l need to convert using a calculated field?

[Clement15]

Sorry, but I don't quite understand your expectations