topic Re: String date to num date in QlikView

String date to num date

gokulnath2592 — Thu, 19 Feb 2015 05:07:36 GMT

Hi all,

In my data, date is in string format.I want to converted it in to number format.

I used below query for the conversion.

date(date#([AssignEndDt ],'MM/DD/YYYY'),'MM/DD/YYYY') as end_date

but it was not working.

Re: String date to num date

ashfaq_haseeb — Thu, 19 Feb 2015 05:23:16 GMT

Hi,

You need to take care of format masking.

Can you upload few sample data to look over.

Regards

ASHFAQ

Re: String date to num date

gokulnath2592 — Thu, 19 Feb 2015 05:28:50 GMT

Hi ashfaq,

I attached my data above.

Re: String date to num date

ashfaq_haseeb — Thu, 19 Feb 2015 05:34:27 GMT

Try like this

date(date#([ProjEndDt],'M/DD/YYYY HH:MM TT'),'MM/DD/YYYY')

=date(date#('1/31/2016 12:30 AM','M/D/YYYY hh:mm tt'), 'MM/DD/YYYY')

Regards

ASHFAQ

Re: String date to num date

jonathandienst — Thu, 19 Feb 2015 05:35:16 GMT

date(date#([AssignEndDt ],'M/D/YYYY hh:mm tt'), 'MM/DD/YYYY') as end_date

HTH

Jonathan

Re: String date to num date

gokulnath2592 — Thu, 19 Feb 2015 05:38:05 GMT

Ashfaq,

I tried your query, Again same will be displayed

Re: String date to num date

gokulnath2592 — Thu, 19 Feb 2015 05:42:11 GMT

jonathan,

I tried your query its working now.

Thanks,

Gokul

Re: String date to num date

ashfaq_haseeb — Thu, 19 Feb 2015 05:43:57 GMT

Try like this

=date(date#('1/31/2016 12:30 AM','M/D/YYYY hh:mm tt'), 'MM/DD/YYYY')

Can you upload your app

Regards

ASHFAQ

Re: String date to num date

gokulnath2592 — Thu, 19 Feb 2015 05:47:36 GMT

Ashfaq,

sorry, I cant upload app.

thanks for your help, date format is changed.

Thanks,

gokul

Re: String date to num date

gokulnath2592 — Thu, 19 Feb 2015 05:49:53 GMT

thank you guys for your help

Regards,

gokul