Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Regards,
May be try this
Date(Date#(Left(FieldName, 8), 'YYYYMMDD'), 'YYYY/MM/DD') as DateField
thanks!
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.
Thanks all!
it's ok.
Hi.. please try this
=Date(Date#([Field Name], 'YYYYMMDD000000'),'MM/DD/YYYY')