Criteria question (1 Viewer)

[AnnPhil]

I need to create a query that will show me the list of Employees that were hired before June 1st of the current year. I have a field called Hired Date and tried to put something in the criteria for this field but nothing worked. example 06/01/Year(Date())

How do write it so it always looks for the current year?

Thanks for any help on this!

 

[raskew]

Hi -

Try this in the criteria cell of your date field:

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

HTH - Bob

 

[AnnPhil]

Thats Bob that worked! However i didn't need all the ) at the end

Very helpful!!!!