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
Icon for Community Champion rankCommunity Champion
9 years ago

xpfc

 

The result of this Column:

 

Planned Defleet = Vehicles[for_disposed_date].[Month]&" "&Vehicles[for_disposed_date].[Year]

in a date like 01/04/2017 is April 2017

 

And when you compare (Using IF) : 

CurrentPlannedDefleet = IF(Vehicles[Planned Defleet] = MONTH(now()),"Defleet", "No")

 

First you have a error because can't compare Text With Integers. 

 

And Also with the Format April 2017 is equal to 4 Result "No" or April 2017 is equal to April Result "No"

 

 

 

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity 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