Rolling Month Forward Query

[Joel84]

Hello Fellow Access Users!

I have to create a query to obtain a rolling forward 30 days/Month in access.

My current date format is dd/mm/yyyy

I do know about the 'dateadd' function, however can this be combined with a query which picks up Today's date (+ 30 Days)?

I am an amateur user in access and am slowly teaching myself!

Thanking you in advance!

 

[Isskint]

the simple answer is........ give it a go. Until you try something you can never know if it works.

But to answer your question, you can use the DATEADD function in a criteria expression in a query. EG to show all records with a SaleDate 30 days from current =DATEADD("d",30,Date()).