Forum Discussion

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
8 years ago
Solved

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 
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    How about:

     

    Measure = DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))

    ?

tsi-kah's avatar
tsi-kah
New Member
7 years ago

How will this return prior year if current month is January?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Here, this should do the trick.

 

Measure =
IF (
MONTH ( TODAY () ) = 1,
DATE ( YEAR ( TODAY () ) - 1, 12, DAY ( TODAY () ) ),
DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, DAY ( TODAY () ) )
)