Date Range Selection

[techvarun]

I have a SQL  table with more than 13 lakh records, I qureried all the records and stored in in a QVD for fast access now i need to show the Data's between two particular date Ranges...

How to fetch values between two range from QVD?

Any why my date field in qvd is a numeric value?

Thanks in advance

Regards

[MayilVahanan]

Hi

Are you want to restrict the date range from script level? If so,

Load * from sample.qvd(qvd) where Date(Floor(ModDate),'MM/DD/YYYY') >= '08/01/2013';

QVDs convert datetime format to number format.

[tresesco · Accepted solution]

try something like this:

Load  *, DateField

From <QVD> where Date(DateField,'MM-DD-YYYY') <'01-01-2013' and  Date(DateField,'MM-DD-YYYY') >= Date(today(),'MM-DD-YYYY') ;

Hope this gives you an idea.

[#4]

Try this,

TEMP:

Load *,SampleDate

FROM SAMPLE.QVD(QVD)

WHERE DATE(SampleDate,'MM/DD/YYYY') > '01/01/2012' AND DATE(SampleDate,'MM/DD/YYYY') < '12/31/2012'

CONCATENATE

Load *,SampleDate

FROM SAMPLE.QVD(QVD)

WHERE DATE(SampleDate,'MM/DD/YYYY') > '01/01/2013' AND DATE(SampleDate,'MM/DD/YYYY') < '12/31/2013'

If i have understood correctly,you meant 2 date ranges

[techvarun]

Fetched the Data's Correct

Thanks