topic Load between dates in QlikView

Load between dates

Tue, 08 Mar 2011 13:06:26 GMT

Hi Guys

This is probably and easy question, but I just cant figure it out ,

I'm loading Excel Spreadsheets into QV, but I wish to only load dates less than today and greater than 6th March 2010.

I have tried :

FROM

(biff, embedded labels, header is 1 lines, table is Drawdown$)

WHERE

Date<Date(Today()) and Date>Date(06/03/2010)

But this is just bringing in all data before Today ( without the 6/3/10 restriction).

I have the dates formated as :

Date(Date) as Date

Month(Date(Date)) as Month

Week

(Date(Date)) as Week

Year(Date(Date)) as Year

Can anyone please help ? Thanks

Tue, 08 Mar 2011 13:49:16 GMT

Hi ,

You have to use

Load

...........

From

......................................

Where

where Date>'06/03/2010' and Date<today();

Hope this will help you.

Thanks&Regards,

Yogesh

Tue, 08 Mar 2011 14:25:43 GMT

Thanks Yogesh ,

Thats perfect