Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jonathan_ineox
New Contributor III

String to date Qliksense

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,

6 Replies

Re: String to date Qliksense

May be try this

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

jonathan_ineox
New Contributor III

Re: String to date Qliksense

thanks!

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

Re: String to date Qliksense

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

Re: String to date Qliksense

What is your original date format.

jonathan_ineox
New Contributor III

Re: String to date Qliksense

Thanks all!

it's ok.

mananmehta900
New Contributor

Re: String to date Qliksense

Hi.. please try this

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

Community Browser