Forum Discussion

xpfc's avatar
xpfc
Frequent Visitor
9 years ago
Solved

IF Month equals Now

Hi   Was trying to work out a basic if on if month is now, but I think because I am trying to use a calculated column this is now working, is there a way to do it using a calculated column?   My ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    xpfc

     

    You can try Using

     

    Column 2 = IF(MONTH(Vehicles[for_disposed_date])=MONTH(Today());"Yes";"No")

     

    This Give you YES is both month are the same but not evalualing the year.

     

    And this evaluate month and Year

     

    Column 2 = if(MONTH([Vehicles[for_disposed_date])=MONTH(TODAY()) && YEAR(Vehicles[for_disposed_date])=YEAR(TODAY());"Yes";"No")

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

xpfc

 

You can try Using

 

Column 2 = IF(MONTH(Vehicles[for_disposed_date])=MONTH(Today());"Yes";"No")

 

This Give you YES is both month are the same but not evalualing the year.

 

And this evaluate month and Year

 

Column 2 = if(MONTH([Vehicles[for_disposed_date])=MONTH(TODAY()) && YEAR(Vehicles[for_disposed_date])=YEAR(TODAY());"Yes";"No")

 

xpfc's avatar
xpfc
Frequent Visitor
9 years ago

Vvelarde

 

Thanks that works great.

 

I had also just rewritten it this way which also gets the required result.

CurrentPlannedDefleet = IF(Vehicles[for_disposed_date].[MonthNo] = MONTH(NOW()),"Defleet", "No")
CurrentPlannedDefleet = IF(MONTH(Vehicles[for_disposed_date]) = MONTH(TODAY()),IF(YEAR(Vehicles[for_disposed_date])=YEAR(TODAY()),"Defleet", "No"),"No")

 

Many Thanks