Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have date field like this 20220928 'yyyymmdd' in qvd so i want load last fifteen days data
@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;
@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;