topic Re: Filtering on date format dd-mmm-yy in QlikView

Filtering on date format dd-mmm-yy

Thu, 23 Jun 2016 10:42:57 GMT

I am filtering my script on sales_date which is in the original format of dd-mmm-yy ie month is text. Is my where clause correct ? As such it will not work.

Load

date(sales_date,'M/D/YYYY'),

Region

FROM [............................]

WHERE sales_date > 01-Jan-2014 ;

Re: Filtering on date format dd-mmm-yy

marcus_sommer — Thu, 23 Jun 2016 10:45:50 GMT

Try this:

Load

date(sales_date,'M/D/YYYY') as Date,

Region

FROM [............................]

WHERE date(sales_date,'DD-MMM-YYYY') > '01-Jan-2014';

- Marcus

Re: Filtering on date format dd-mmm-yy

Kushal_Chawda — Thu, 23 Jun 2016 10:50:36 GMT

should be

WHERE date(sales_date,'DD-MMM-YYYY') > date#('01-Jan-2014','DD-MMM-YYYY');

Re: Filtering on date format dd-mmm-yy

Digvijay_Singh — Thu, 23 Jun 2016 10:53:59 GMT

WHERE date(date#(sales_date,'DD-MMM-YYYY'),'DD-MMM-YYYY') > '01-Jan-2014';