Query that looks for dates within a window

Databases
1

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”

Thanks

2

If you are using SQLite:

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

Brandon
Works like a charm. Much thanks!!!
Jim