report to pull birthday two months in advance

[Hinky]

I had been using this:

extract(month,[My Employees].[EEO/I-9].[Birth Date]) = extract(month,current_date) +2

to pull a report of employees who had a birthday two months from the current date.. but it suddenly stopped working.

Any ideas as to why? I've not changed anything in the report.

Thanks so much!   :)

[Lynn]

I think it is because you are adding the number 2 to the extracted month. The month number for November plus 2 equals month 13 and there ain't no such critter.

Add two months to the current date and then extract the month.

[CognosPaul]

ahem ::)