Date "string" as parameter!

[Paul Clark]

I am trying to set a criteria field to look for >#01/09/[current year]# but every combination of Date() returns invalid value.
Any clues?

 

[John Big Booty]

Welcome to the Forum.

You are going to need to use the DatePart() and DateSerial() functions. Your criteria will look something like;

># DateSerial(DatePart(Date(),"yyyy"),9,1) #

 

[Paul Clark]

The actual format of code the did the job was:
DateSerial(DatePart("yyyy",Date()),9,1)

Excellent

 

[boblarson]

I would have gone with YEAR instead of DatePart:

DateSerial(Year(Date()),9,1)

that is even less typing

 

[John Big Booty]

Doh, so would I, had I noticed the Year() function