(dt_date)((dt_wstr, 4)year(dateadd("mm", -1, getdate()))+"-"+ right("0"+(dt_wstr,2)month(dateadd("mm", -6, getdate())),2)+"-01")
I need to get a default date as 01st March 2022.
(dt_date)((dt_wstr, 4)year(dateadd("mm", -1, getdate()))+"-"+ right("0"+(dt_wstr,2)month(dateadd("mm", -6, getdate())),2)+"-01")
I need to get a default date as 01st March 2022.