This expression does not work(returns NA):
Code: Select all
@dateadd(@now,-1,"mm")
I think that is because February does not have the day 30. However, in most languages this sort of expression works.
For instance, in TSQL:
Code: Select all
select dateadd(month,-1,cast(GETDATE() as date))
----------
2016-02-29
(1 row(s) affected)
I have already made an workaround, so it is not urgent, but this behavior is erratic, and I would like this fixed.