//Contact A Start Date Iif(Month(@mailDate) in(01,02,03), ToDate(ToString(Month(SubMonths(@mailDate,3))) + '/01' + '/' + ToString(Year(SubYears(@mailDate,1)))),ToDate(ToString(Month(SubMonths(@mailDate,3))) + '/01' + '/' + ToString(Year(GetDate())))) //Contact B Start Date Iif(Month(@mailDate) in(01,02,03,04,05,06), ToDate(ToString(Month(SubMonths(@mailDate,6))) + '/01' + '/' + ToString(Year(SubYears(@mailDate,1)))),ToDate(ToString(Month(SubMonths(@mailDate,6))) + '/01' + '/' + ToString(Year(@mailDate)))) //Contact C Start Date Iif(Month(@mailDate) in(01,02,03,04,05,06,07,08,09), ToDate(ToString(Month(SubMonths(@mailDate,9))) + '/01' + '/' + ToString(Year(SubYears(@mailDate,1)))),ToDate(ToString(Month(SubMonths(@mailDate,9))) + '/01' + '/' + ToString(Year(@mailDate))))
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter