sql : use current year as criteria

[boomer1974]

Hello experts,

I am having a terrible time getting this where statement to work. All I want to say is: SELECT * FROM mytable WHERE mytable.date > 02/01/(of last year). Of course the (of last year) part is the part of the syntax that I cannot get to work. I know I can use the DatePart function but I cannot get past the syntax errors. Thanks in advance for any help you can provide.

Ryan

 

[KenReay]

Hi

How about

"SELECT * FROM mytable WHERE mytable.date > #" & Format("02/01/" & Str(Year(Date())-1)."mm/dd/yy&quot & "#;"


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[TonyJollans]

Hi boomer1974,

Or ...

"SELECT * FROM mytable WHERE mytable.date > DateSerial(Year(Date())-1,2,1);"

(where the 2 is the month and the 1 the day - I don't know what format date you're using in your example).

Enjoy,
Tony

 

[boomer1974]

Thanks Guys, that worked perfectly

boomer