Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Previous month issue

Hello,    I need to extract previous month for today.  I tried previousmonth= date(year(today ()),month(today) - 1,day(today())) But it displays 02/03/2021 which is wrong, how to correct it pleas...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , because there is no 30th in feb , Try a measure like

     

    previousmonth = Var _1 = date(year(today ()),month(today()) - 1,day(today())) Return if(EOMONTH(today(),-1) < _1, EOMONTH(today(),-1) , _1)
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , because there is no 30th in feb , Try a measure like

 

previousmonth = Var _1 = date(year(today ()),month(today()) - 1,day(today())) Return if(EOMONTH(today(),-1) < _1, EOMONTH(today(),-1) , _1)