Filtering on date format dd-mmm-yy

[#1]

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 ;

[marcus_sommer]

Try this:

Load

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

Region

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

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

- Marcus

[Kushal_Chawda]

should be

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

[Digvijay_Singh]

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