filtering data on date while fetching from SAP

sudeep_d — Tue, 25 Sep 2012 11:51:45 GMT

Hi,

zicrm:

load

/bic/submiton,

zcaldate,

z_z4

sql select /bic/submiton,zcaldate,z_z4 from /bic/zicrm;

In the above mentioned eg, i want to filter data on datefield i.e(/bic/submiton) for last two days including today,

where /bic/submiton has data in text format e.g: 01-aug-2012,

now how do i convert this text into date format and compare with todays date in sql and fetch only last 2 days data

in short ,what should be my where statement to get last two days data???

any help would be appreciated

Thanks

Sudeep

topic filtering data on date while fetching from SAP in QlikView