Alert for Position ending in 6 months

[enquiries]

Hi there,



I'm trying to find the right formula to put in a query to show all details for a position that has an end date appointment 6months away from now.

So basically in human terms:

(End Date of Appointment-Today) <= 6 months

So there is less then or equivalent of 6 months between end date of appointment and today. My current formula in the query is:
=(((DateDiff("m",[End Date of Appointment],Now()))+Int(Format(Now(),"mmdd")<Format([End Date of Appointment],"mmdd"))) Mod 12)<=6

Would appreciate any help please.
Thanks,

[June7]

Probably need the year in there somewhere. If you don't want any appointment records before today, try:

[End Date of Appointment] BETWEEN Date() AND Date() + 180

or

Format([End Date of Appointment],"yyyymm") BETWEEN Format(Date(),"yyyymm") AND Format(DateAdd("m",6,Date()),"yyyymm")

Why do you show an = sign at beginning of that expression?

[enquiries]

Hi June, thanks that makes much more sense now

End date has to be between now and 6 months from now.

The = sign was a silly mistake, I was trying to put a formula in without realizing it was prompting for the criteria to "equal" the expression.

Thanks again for your help