Query that looks for dates within a window

I’m trying to write a query that only returns rows where the entry in a date field is between “Now” and “now+30” days

query = Select field1, field2 from Table where “Datefield” is between “now” and “now+30”


If you are using SQLite:

SELECT field1, field2 
FROM mytable
WHERE Datefield BETWEEN date('now') AND date('now', '+30 days');

1 Like

Works like a charm. Much thanks!!!