Discussion board where members can get started with Qlik Sense.
I am new to Qliksense. I have a field in this format YYYYMMDD000000 I want to convert to date YYYY / MM / DD how can i do?
I tried thid function date (FieldName, 'YYYYMMDD000000') it did not work
thank you for helping me
May be try this
Date(Date#(Left(FieldName, 8), 'YYYYMMDD'), 'YYYY/MM/DD') as DateField
I put Date(Date#(dt_enreg_cmde,'YYYYMMDDhhmmss'),'DD/MM/YYYY hh:mm:ss') :-)
I thought you only needed Date part of the string... anyways I am glad you were able to figure it out
What is your original date format.
Hi.. please try this
=Date(Date#([Field Name], 'YYYYMMDD000000'),'MM/DD/YYYY')