tag:blogger.com,1999:blog-1369617592691853013.post2158094689533892116..comments2022-07-07T19:38:47.492-07:00Comments on Brent Greenwood's blog: SSIS Expressions and Quarter Start DatesBrent Greenwoodhttp://www.blogger.com/profile/12869824548741734775noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1369617592691853013.post-55547423754174060982014-11-23T09:02:16.112-08:002014-11-23T09:02:16.112-08:00Just subtract a day from current quarter start dat...Just subtract a day from current quarter start date like:<br />DATEADD( <br />"day"<br />,-1<br />,(DT_DATE)<br />(<br />(DT_STR,4,1252)(YEAR(GETDATE())) <br />+"-"<br />+ (RIGHT(<br /> "0" <br /> + (DT_STR,2,1252)(((DATEPART("q", GETDATE() )-1)*3)+1)<br /> + "-01",5<br /> )<br /> )<br />)Brent Greenwoodhttps://www.blogger.com/profile/12869824548741734775noreply@blogger.comtag:blogger.com,1999:blog-1369617592691853013.post-27595891352071153702014-09-05T07:23:31.775-07:002014-09-05T07:23:31.775-07:00How would you get Quarter End Dates for last quar...How would you get Quarter End Dates for last quarter?<br />Anonymoushttps://www.blogger.com/profile/07883285777177393669noreply@blogger.com