3 Months from January of this year

[Guest]

I'm trying to format a query to determine if the hire date of an employee is
within 3 months before January of the current year. Here is what I have so
far and it's not working, can someone please help?

Flag: ([Staff]![DateHired])-Format(("1/1/" &
Format(Now(),"yyyy")),"m","dd",Now())

 

[Amy Blankenship]

I'm trying to format a query to determine if the hire date of an employee
is
within 3 months before January of the current year. Here is what I have so
far and it's not working, can someone please help?

Flag: ([Staff]![DateHired])-Format(("1/1/" &
Format(Now(),"yyyy")),"m","dd",Now())

Try using DateDiff.

HTH;

Amy

 

[Ken Snell \(MVP\)]

Assuming that the flag should be True or False (True if the hire date with
between October 1 and December 31 of the previous year):

Flag: (Staff.DateHired Between DateSerial(Year(Date())-1,10,1) And
DateSerial(Year(Date())-1,12,31)