Using date function with inline prompt

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am using the Now() function and trying to use a variable input to go back a
couple of days for checking dates. In the Date Column, I am using >Date() -
3 to go back 3 days as a hard code. When I change it to a inline prompt it
does not work ie. > Date() - [Enter number of days before now]. How best can
I get this to work?
 
My first choice would be to use the DateAdd function
DateAdd("d",-[Enter number of days before now],Date())
Click to expand...

Or force the parameter value type
Date() - CInt([Enter number of days before now])
Click to expand...

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
I am using the Now() function and trying to use a variable input to go back a
couple of days for checking dates. In the Date Column, I am using >Date() -
3 to go back 3 days as a hard code. When I change it to a inline prompt it
does not work ie. > Date() - [Enter number of days before now]. How best can
I get this to work?
Click to expand...
 
Back
Top