cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JoseMilhazes Frequent Visitor
Frequent Visitor

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
RolandsP Member
Member

Re: True/False in a new field after comparing two dates

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

View solution in original post

Highlighted
JoseMilhazes Frequent Visitor
Frequent Visitor

Re: True/False in a new field after comparing two dates

Did work thank you!!

View solution in original post

2 REPLIES 2
RolandsP Member
Member

Re: True/False in a new field after comparing two dates

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

View solution in original post

Highlighted
JoseMilhazes Frequent Visitor
Frequent Visitor

Re: True/False in a new field after comparing two dates

Did work thank you!!

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 6 members 2,141 guests
Please welcome our newest community members: