Time Windows add-on ± 1 and ± 3 Day

Calendar Time Windows ±1 and ±3 Days

± 1 days 20

TABLE WITHOUT ID
file.link as Note,
dateformat(created, "yyyy-MM-dd") as "Date Created"
 
FROM ""
 
WHERE date(this.file.ctime) - file.ctime <= dur(1 days)
 
SORT file.ctime asc
 
LIMIT 20

± 3 days 30

TABLE WITHOUT ID
file.link as Note,
dateformat(created, "yyyy-MM-dd") as "Date Created"
 
FROM ""
 
WHERE date(this.file.ctime) - file.ctime <= dur(3 days)
 
SORT file.ctime asc
 
LIMIT 30