The date+time filter is adding full days/hours/etc., so it cannot give you things like 7 days ago at midnight
. You can however use the JavaScript
filter condition to get any date value you want.
To get midnight 7 days ago, you could use this expression to compare any datetime attribute value against:
let d = new Date(); return Math.floor(new Date(d.getFullYear(), d.getMonth(), d.getDate() - 7).getTime() / 1000);
This expression gives you the unix timestamp of midnight 00:00 of your local time, 7 days in the past. If you want to compare datetime values, this is what you would use.
If you want to filter for date values, you would use midnight 00:00 of UTC time instead of your local time.