Forum Discussion
Baskar
Resident Rockstar
Resident RockstarPrevious 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 would not work for January because it would get December of current year, not of prior year.