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 please? 

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)

1 Reply

  • 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)