topic Re: Converting text field to a date in QlikView

Converting text field to a date

Mon, 29 Jul 2013 18:19:08 GMT

The format for [RECEIVED DATE] is 20130402. I need to get all the records that are 2013 or greater. I've tried Num#(Left([RECEIVED DATE],4) > 2013, , but not having any luck. Can someone help me, please.

Re: Converting text field to a date

jerem1234 — Mon, 29 Jul 2013 18:34:17 GMT

try this:

Date(Date#([RECEIVED DATE], 'YYYYMMDD'), 'YYYY')>=2013

Re: Converting text field to a date

Mon, 29 Jul 2013 19:27:50 GMT

If that does not work, try changing it on the script when you load the data:
SET TimestampFormat='YYYYMMDD';
That will recognize that format as being a date

Regards,

Pablo

Re: Converting text field to a date

MayilVahanan — Mon, 29 Jul 2013 22:26:30 GMT

Try like this

Year(Date#([RECEIVED DATE], 'YYYYMMDD')) >= 2013

Re: Converting text field to a date

VishalWaghole — Tue, 30 Jul 2013 08:28:26 GMT

Please try this

Date( Date#([RECEIVED DATE], 'YYYYMMDD'),'YYYY') >= 2013

and if RECEIVED DATE having Timestamp formate then

try this

Date( Date#([RECEIVED DATE], 'YYYYMMDD hh:mm:ss'),'YYYY') >= 2013

hope that will solve ur problem.

Thanks.

Re: Converting text field to a date

Tue, 30 Jul 2013 17:00:51 GMT

Thank you!