True/False in a new field after comparing two dates

[Anonymous]

Hi all, thank you in advance for your assistance.

I have one dataset bringing two dates: Due Date and Done Date. I need to compare the two dates. If the job was done on the same month/year of due date is true, if not False. As new column.

Done date     Due date      True/False

Jun.09.2013   Jun.12.2013  True

Jun.12.2013   Jul.15.2013    False

Regards

Jose Milhazes

[RolandsP · Accepted solution]

One way how to get this would be:

True/False = IF ( CONCATENATE(MONTH(Sheet1[Due date]), YEAR(Sheet1[Due date])) = CONCATENATE(MONTH(Sheet1[Done date]), YEAR(Sheet1[Due date])), "True", "False")

[RolandsP · Accepted solution]

One way how to get this would be:

True/False = IF ( CONCATENATE(MONTH(Sheet1[Due date]), YEAR(Sheet1[Due date])) = CONCATENATE(MONTH(Sheet1[Done date]), YEAR(Sheet1[Due date])), "True", "False")

[Anonymous · Accepted solution]

Did work thank you!!