String to date Qliksense

[Anonymous]

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,

[sunny_talwar]

May be try this

Date(Date#(Left(FieldName, 8), 'YYYYMMDD'), 'YYYY/MM/DD') as DateField

[Anonymous]

thanks!

I put   Date(Date#(dt_enreg_cmde,'YYYYMMDDhhmmss'),'DD/MM/YYYY hh:mm:ss') 🙂

[sunny_talwar]

I thought you only needed Date part of the string... anyways I am glad you were able to figure it out

[its_anandrjs]

What is your original date format.

[Anonymous]

Thanks all!

it's ok.

[mananmehta900]

Hi.. please try this

=Date(Date#([Field Name], 'YYYYMMDD000000'),'MM/DD/YYYY')