sql server mseq: how do I find all records that were created before
today minus 150 days. I could easily do this in MsAccess
by doing the following

by filtering off of the Date created field using the

you can get today minus 150 days with the help of either of following
expression, 1st will not remove time component whereas 2nd will remove time
component from today's date and will go back 150 days.

getdate() - 150

--OR
(convert(datetime,convert(varchar(8),getdate(),112)) - 150)

--
Vishal Parkar
vgparkar@yahoo.co.in | vgparkar@hotmail.com