I have date field like this 20220928 'yyyymmdd' in qvd so i want load last fifteen days data

[Vinni2000]

I have date field like this 20220928 'yyyymmdd' in qvd so i want load last fifteen days data

[Kushal_Chawda · Accepted solution]

@Vinni2000  try below

Data:
LOAD *
FROM Source;

max_date:
LOAD max(Date) as max_date;
Load FieldValue('Date',RecNo()) as Date
AutoGenerate FieldValueCount('Date');

let vMaxDate = Peek('max_date');

Final:
NoConcatenate
LOAD *
Resident Data
where Floor(Date#(Date,'YYYYMMDD'))>= Floor(Date#('$(vMaxDate)','YYYYMMDD'),-2)-14;

Drop Table Data;

If your data is updated regularly in your QVD, You can use today() or today()-1 like below

Data:
LOAD *
FROm Source
where Floor(Date#(Date,'YYYYMMDD'))>= Floor(today())-14;