SQL Code for todays date -90 days

[kbaisch]

I have this code set up but I know the 3rd line is wrong. Could someone please help me on the code for pulling all entries for todays date -90 days? I would really appreciate it and thanks for helping.

SELECT *
from view1_4t
where DOB_ = (getdate()-90)
GO

[sandyboy]

I have this code set up but I know the 3rd line is wrong. Could someone please help me on the code for pulling all entries for todays date -90 days? I would really appreciate it and thanks for helping.

SELECT *
from view1_4t
where DOB_ = (getdate()-90)
GO

Try this code

Select * from view1_4t where dob=dateadd(dd,-90,getdate())

[MMcCarthy]

You have posted this question in the Articles section. I am moving it to the SQL Server forum.

ADMIN