Creating a query WHERE Date>1/1/[current year]

[What]

I'm trying to update a dozen or more queries that have january first of 2009 hard coded into them. So that I'm not doing this same thing again this time next year, I was hoping someone could provide me with the correct syntax for criteria of 1/1/[current year].

I've searched the forums and scoured what google returns, and still can't find out how to get the syntax to jive with access.

WHERE ((tbl.fieldDate)>#1/1/[Year(Date())]#)

Doesn't work - Anyone know how to do this?

 

[boblarson]

Use DateSerial:

WHERE ((tbl.fieldDate)> DateSerial(Year(Date),1,1))

 

[What]

Wow, that was really quick. Thanks for the help, looks like that function is just what I need!

 

[boblarson]

Yep, it is a good one to remember. It comes in handy quite often.

 

[AnnPhil]

I tried this function for one of my queries and it didn't work. Could you take a look at it and let me know if you can see why it wouldn't work. Thanks

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.

 

[stopher]

I tried this function for one of my queries and it didn't work. Could you take a look at it and let me know if you can see why it wouldn't work. Thanks

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.

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

hth
Chris

 

[AnnPhil]

Thanks that worked perfect!