Date epression

  • Thread starter Thread starter boz
  • Start date Start date
B

boz

does anyone know how to retrieve records in a query like 2 weeks from the
current date? Example I know i have some authorizations about to expire and I
would like notification before they expire. So what expression could I use to
find the ones that are about to expire? thanks
 
See answer below - use in the critera row

But a better idea would be to send the criteria from a form - a nice idea I
have used in the past is to set up an option group and use the AfterUpdate
event to set the criteria for a QBF.

It works really well, it very simple, users like it
 
does anyone know how to retrieve records in a query like 2 weeks from the
current date? Example I know i have some authorizations about to expire and I
would like notification before they expire. So what expression could I use to
find the ones that are about to expire? thanks
Click to expand...

As criteria on the Date column, write:
Between Date() and Date()+14

or you could use

Between Date() and DateAdd("ww.2,Date())
 
Back
Top