cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

@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

View solution in original post

3 REPLIES 3
Highlighted
Community Champion
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

@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

View solution in original post

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

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors