| Author |
Topic |
|
humanpuck
Yak Posting Veteran
94 Posts |
 Posted - 2006-08-10 : 13:27:40
|
| To get the first and last day of the last month?comm_date >= dateadd(dd,-datepart(dd,dateadd(mm,-1,dateadd(day,datediff(day,0,GETDATE()), 0))), dateadd(mm,-1,dateadd(day,datediff(day,0,GETDATE()), 0)))+1 and comm_date <= dateadd(dd,-datepart(dd,dateadd(mm,-1,dateadd(day,datediff(day,0,GETDATE()), 0))), dateadd(day,datediff(day,0,GETDATE()), 0)) |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-10 : 14:22:26
|
quote:
Originally posted by humanpuck
To get the first and last day of the last month?comm_date >= dateadd(dd,-datepart(dd,dateadd(mm,-1,dateadd(day,datediff(day,0,GETDATE()), 0))), dateadd(mm,-1,dateadd(day,datediff(day,0,GETDATE()), 0)))+1 and comm_date <= dateadd(dd,-datepart(dd,dateadd(mm,-1,dateadd(day,datediff(day,0,GETDATE()), 0))), dateadd(day,datediff(day,0,GETDATE()), 0))
Seems like the hard way to do it.This code is a little simpler:select comm_date >= dateadd(mm,datediff(mm,0,getdate())-1,0) and comm_date <= dateadd(mm,datediff(mm,-1,getdate())-1,-1) You may want to look at these links.Start of Time Period Functions:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64755Start of Week Function:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47307End Date of Time Period Functions:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64759End of Week Function:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64760CODO ERGO SUM |
 |
|
|
|
|
|
Is there a better way