Reminder for deadlines using Dataview

Help
3

Hi, you could try

TABLE deadline
FROM "inbox/scadenze"
WHERE deadline >= dateformat("25-07-2023", "dd-MM-yyyy") AND deadline <= dateformat("09-08-2023", "dd-MM-yyyy")

or, alternatively

TABLE deadline
FROM "inbox/scadenze"
WHERE date(deadline, "dd-MM-yyyy") >= date("2023-07-25") AND date(deadline, "dd-MM-yyyy") <= date("2023-08-09")

If you want this to be dynamic, you could try something like this:

TABLE deadline
FROM "inbox/scadenze"
WHERE date(deadline, "dd-MM-yyyy") >= date(now) AND date(deadline, "dd-MM-yyyy") <= date(now) + dur(15 d)