Limit data load with date field

[shakeeb_mohammed]

Hi , 

I have a large QVD which is getting built from a database - i have some miscellaneous date fields which is messing up with my application - e.g. i may have a date field from years 1999 and in some cases 2099. I want to put in my script only load data from today's date and 94 days going back. Can someone help me write this script please? 

[amrinder · Accepted solution]

Hi Shakeeb,

First create a variable like this:

Let vToday= Date(Today()-94,'DD/MM/YYYY');

Then while loading QVD in where clause pass this variable llike this:

Load

CustomerID,

ProductID,

BillingDate

From ABC.qvd  where Date>='$(vToday)';

Hope it helps.

-amrinder

[shakeeb_mohammed]

Thank you!