i want to load last one year data while loading to QVD from DB
i have a Month Field
201806 like that
and i have a Quarter filed like below
2018Q2 like so on...
Solved! Go to Solution.
Load * From Table;
Store Table into ../../Store.qvd (qvd) Where Year = Year(Today());
Do you want to load the data from 201708 to till date? If so, try
Let vVar = Date(Monthend(AddMonths(Today(),-12)),'YYYYMM'); //201708
DB Path where CreatedMonth >= $(vVar);