Date Query using date in the date field

  • Thread starter Thread starter Shoan
  • Start date Start date
S

Shoan

In my database I have a field in my personnel table that determines the date
when a person will leave. I've been trying to create a query that will give
me the number of days equal to 365 days or sometimes 90 days from that date.
I've tried this.

Criteria: Now() <= [type in number in days] departure date.

I'm so lost I don't know what to do anymore.

Shoan
 
Can not figure what you want. Do you want all records that will be departing
in the next [type in number in days] number of days?
Or do you want to know who departed [type in number in days] number of days
ago?
 
You can use the dateadd function to add a number of days to a date.

If you are trying to find persons who have a departure date between
today and 365 days from today you could use

Criteria: Between Date() and DateAdd("D",365,Date())

You can replace the 365 with your parameter prompt.

Criteria: Between Date() and DateAdd("D",[Enter Number of Days],Date())

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top