date year is more then a year ago

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

date year is more then a year ago

Author

Topic

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2006-03-26 : 06:29:08

SELECT [Name of Programs].EndingDateOfProgram, [Name of Programs].NameOfProgram
FROM [Name of Programs]
WHERE ((([Name of Programs].EndingDateOfProgram)>Year(Date())-1));

this is in access and is not working

what i want in the where are all programs where endingdateofprogram ended more then a year ago.

nr
SQLTeam MVY

12543 Posts

Posted - 2006-03-26 : 10:54:28

[Name of Programs].EndingDateOfProgram) < dateadd("y",-1,now())

Haven't tried it.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources