Please help to get the SSIS expression of First Day and Last Day of Previous month

Question

Can anybody please help me to get the SSIS expression of First Day and Last Day of Previous month in the below format.

yyyy-mm-dd.

Currently I am hardcoding it as 2022-09-01 and 2022-09-30 respectively.

Any suggestion will be helpful.

Answer 1

Hi @Subhomoy Chakraborty ,

Here is an exact answer on your question: pass-first-and-last-day-of-the-previous-month-in-ssis-execute-sql-task

Answer 2

Hi @Subhomoy Chakraborty ,

First Day:

(DT_WSTR, 4)YEAR(DATEADD("mm", -1, GETDATE())) +"-"+ RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("mm", -1, GETDATE())),2)+"-"+"01"  

Last Day:

(DT_WSTR,4) YEAR(DATEADD( "day", -DAY( GETDATE() ) ,GETDATE())) + "-"  
+RIGHT("0"+(DT_WSTR,2) MONTH(DATEADD( "day",  -DAY( GETDATE()),GETDATE()) ), 2) +"-"+RIGHT("0"+(DT_WSTR,2) DAY(DATEADD( "day",  -DAY( GETDATE()) ,GETDATE()) ),2)  

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.