Start Date within last 12 months

[Bruum]

Hi there

Can someone help with date query. I need to bring up only staff members
with a start date within the last 12 months. This is then grouped into
quarters to display winning Rookie of the quarter.

Added complication is that if the staff member started in say August 2005,
they would not qualify for the July-September quarter, as they would be over
12 months in that period, so they would fall off the graph at the end of the
March-June quarter.

I have an existing query with the old criteria for "StartDate" being

 

[Douglas J. Steele]

Try StartDate > DateAdd("yyyy", -1, Date())

 

[Ofer Cohen]

Try

Where [start date] Between DateAdd("m",-12,Date()) And Date()

 

[Bruum]

Thank you Ofer and Douglas for your very prompt reply. Both worked fine, and
can now sleep at night

Try

Where [start date] Between DateAdd("m",-12,Date()) And Date()

--
Good Luck
BS"D

Hi there

Can someone help with date query. I need to bring up only staff members
with a start date within the last 12 months. This is then grouped into
quarters to display winning Rookie of the quarter.

Added complication is that if the staff member started in say August 2005,
they would not qualify for the July-September quarter, as they would be over
12 months in that period, so they would fall off the graph at the end of the
March-June quarter.

I have an existing query with the old criteria for "StartDate" being