SQL: Data of the last 7 days

somi — Mon, 26 Jan 2026 16:26:21 GMT

Hello all,

I would like to filter all data in the script (SQL) by a date. I want all the data that was created in the last 7 days.

I searched a little in the forum, unfortunately my solution does not work....

Can someone help me?

SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

LOAD "rechnung_dbid", "beleg_date";
SQL SELECT "rechnung_dbid", "beleg_date"
FROM pdserp."public"."pds_rechnung"
WHERE Interval(Date#($(TodayDate), 'DD.MM.YYYY') - Date#("beleg_date", 'DD.MM.YYYY'), 'DD') < 7;

Thanks Many greetings
Martin

Re: SQL: Data of the last 7 days

Thiago_Justen_ — Sun, 17 Oct 2021 06:50:37 GMT

Hi there, try this out:

SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

Let vFilterDate = Date(today()-7);

LOAD "rechnung_dbid", "beleg_date";
SQL SELECT "rechnung_dbid", "beleg_date"
FROM pdserp."public"."pds_rechnung"
WHERE Num(beleg_date) > '$(vFilterDate)' ;

Regards

topic SQL: Data of the last 7 days in QlikView

SQL: Data of the last 7 days

Re: SQL: Data of the last 7 days