Thursday, October 11, 2012

Calculate beginning of the previous month

 Calculate beginning of the previous month
 Expression on component or task:
(DT_DATE)(DT_DBDATE)DATEADD("dd",-1*(DAY(GETDATE())-1),DATEADD("month", -1, GETDATE()))

No comments:

Post a Comment