Forum Discussion
True/False in a new field after comparing two dates
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
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")
2 Replies
RolandsPResolver IV
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")