DateAdd Function

[luvmy2kids]

I have the below formula:

SELECT DATEADD(year, -1, getdate()) - which returns:
2008-07-21 12:03:32.733
--I need it to return the time as 00:00:00.00

Also in my report what I need to accomplish is a date range:

checkdate between DATEADD(year, -1, getdate()) and 30 days(the previou 30 days). In other words:

checkdate between '6-21-2008' and '7-21-2008'

Any help on this would be greatly appreciated!!

Thanks a million.....

 

[markros]

declare @d datetime
set @d = DATEADD(year, -1, getdate())
SELECT @d, cast(CONVERT(varchar(30),@d,112) as datetime)

 

[bborissov]

SELECT DATEADD(yy,-1,DATEADD(dd,0,DATEDIFF(dd,0,GETDATE())))

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[markros]

Please also read this

http://www.karaszi.com/SQLServer/info_datetime.asp#GettingRidOfTimePortion

so Borisslav's approach would be better

 

[luvmy2kids]

Thanks for the help!

 

[bborissov]

markros,
PLEASE do not call me Borislav.
That way all call me when I do something wrong
Boris is enough

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[markros]

Boris,

I also introduced a typo in your full name - sorry.

May I call you Bor for short? Just kidding.

 

[bborissov]

You can call me whatever you like )))
Just not Borislav

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[markros]

Ok, honey

 

[markros]

This is irrelevant for this problem, but since it's a commonly asked question, I wanted to pass this info along

http://forum.lessthandot.com/viewtopic.php?f=17&t=6819&p=34697#p34697