Hello
Any idea why this IF statement does not work?
DECLARE @LastDateOfLastMonth varchar = '2020-01-30'
DECLARE @LastMonthSingleDigit varchar = IF(RIGHT(RIGHT(LEFT(@LastDateOfLastMonth,7),2),1)='0',REPLACE(RIGHT(LEFT(@LastDateOfLastMonth,7),2),'0',''),RIGHT(LEFT(@LastDateOfLastMonth,7),2))
Thanks!