cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## 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 Calculated column is:

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

There I am just trying to look up this month, I have tried the following methods get errors.

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

And have also tried:

`CurrentPlannedDefleet = IF(Vehicles[Planned Defleet] = FORMAT("April",MONTH(4)),"Defleet", "No")`

This one just returns "No" down the whole list when I definatley have some as "April 2017"

Hence my assumption it maybe to do with it being a calculated column.

Any pointers in the right direction would be appreciated.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion

@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")

Lima - Peru
3 REPLIES 3
Highlighted
Community Champion

@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"

Lima - Peru
Highlighted
Community Champion

@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")

Lima - Peru
Highlighted
Frequent Visitor

@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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors