Forum Discussion
Previous Month from NOW() or Today()
Thanks Advanced, I have to get Previous month from NOW() or TODAY(). While using DATEADD or PREVIOUSMONTH it was asking Dates as columns. It won't allow this two functions. Greg_Deckler
How about:
Measure = DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))
?
Greg_Deckler
Community Champion
Community ChampionHow about:
Measure = DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))
?
This will not give you last month's date for months with no day 31 or Feb 29