DateSerial function

[AnnPhil]

I am having a promblem with the DateSerial function and hope someone can help.

Here is what i put in the criteria of the Hired Date

<=DateSerial(Year(Date()-1),6,1)

I need it to return all employees that were hired less then or equal to

June 1, 2009

Instead it is including employees hired in Nov and Dec of 2009!

Any help on this is appreciated.

 

[Galaxiom]

Brackets in the wrong place.
<=DateSerial(Year(Date())-1,6,1)

 

[AnnPhil]

Thanks Galaxiom, I don't know what i would do without you guys