Access 2007 - Date Serial

  • Thread starter Thread starter Cettina
  • Start date Start date
C

Cettina

I want to set up a criteria for the Date Serial where I want to be able to
run a report that will allow me to enter a date and then be able to tell me
what is going to be coming up due as of 30 days from the date entered.
I am not sure what the formula is to make this happen and anything that I
look for is not helping me.
 
I want to set up a criteria for the Date Serial where I want to be able to
run a report that will allow me to enter a date and then be able to tell me
what is going to be coming up due as of 30 days from the date entered.
I am not sure what the formula is to make this happen and anything that I
look for is not helping me.
Click to expand...

Use DateAdd instead:
= [date entered] AND < DateAdd("d", 30, [date entered])
Click to expand...
 
This should do it --
Between CVDate([Enter date (11/24/2010)]) AND DateAdd("d", 30,
CVDate([Enter date (11/24/2010)]))

Or this --
Between CVDate([Forms]![YourFormName]![TextBox]) AND DateAdd("d", 30,
CVDate([Forms]![YourFormName]![TextBox]))
 
Back
Top