Query Number of Days From Today in Microsoft Access

Access understands DATE() as being the date your system reports right now, or as geeks call it, the "system date".

In the demonstration, we query the TDate in tblTrips for any records dated between today and 30 days from today.