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...
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")
Did work thank you!!
RolandsP
Resolver IV
Resolver IVOne 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")
Did work thank you!!