How can I manage dates in a query?

  • Thread starter Thread starter hanski
  • Start date Start date
H

hanski

Hi.

I have a field called StartingDate in my table.

I would like to make a query where it asks the user to input valid
parameters. I put in the query a parameter concerning the StartingDate
field:

Between [Give me your starting date] and [Give me your ending date].

User wants, that if the starting date and ending date are today, so he
would like to only press enter twice and not inputting anything. Is it
possible to make a supposition that query, so that if user only press
enter it will be today?


hanski
 
Try:

Between Nz([Give me your starting date], Date()) and Nz([Give me your ending
date], Date())
 
Back
Top