how to show date before 1 year ago?

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

Greeing,

Is there any way to show date before 1 year from specific date in query??
once the query opened , a dailog box shows and aske about the date.

thanks!!
 
Hello Jon.

Jon said:
Is there any way to show date before 1 year from specific date in
query?? once the query opened, a dailog box shows and asks about
the date.
Click to expand...

DateAdd("yyyy", -1, Date())
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Modifying date information 1
Year Comparison Report 6
Query - Date - Month Plus One? 3
How to show qry "criteria" on a report ? 10
Sorting by Month and Year in Query 2
Hello happy new year to all, Text box input for year of purchase 0
Query Results in a Text Box 3

Back
Top