>#12/31/&Year(Date())# Help with proper syntax, plea

[jayd77]

>#12/31/&Year(Date())# Help with proper syntax, please!

I am using this for criteria in a query.

 

[jayd77]

I mean >#12/31/&Year(Date())-1#

greater than last year

I need the year to equal the current year if not the record should not show up.

Year(Date()) doesn't seem to work either

 

[Rocky E]

Hi Jay,
Use the immediate window to see what functions return until you get a grip on them. If the field is fldSomeDate then Year([fldSomeDate]) > (Year(Date()) -1) should work without the 12/31 stuff.