Comparing two workdates to return the latest date.

Question

I have a project management app that uses predecessors. There are two possible outcomes in my workflow where I want to compare two different task completion dates and use the highest as the project finish date.
I created two summary fields based on my two possible task completion dates (work dates). Then I created a formula date field to show the result of the comparison. I was trying to use the MAX function:

MAX([summary date 1],[summary date 2])

I am getting a syntax error, and I have had no luck rearranging the components of the formula. Has anyone else used MAX on work dates?

quickbasecoachd · Answer

What is the syntax error - but aside from that, try thisdMax(ToDate([summary date 1], ToDate([summary date 2]))Maybe those summary fields are Work date field types.

sharonneville · Answer

Good Morning!Now&nbsp;the error is&nbsp;a mismatched set of parenthesis....Max(ToDate([Summary 2 of Final task date completed], ToDate([Summary of final task date completed]))&nbsp;&nbsp;Yes, Both of the Summary dates are WorkDates.

quickbasecoachd · Answer

Try thisMax(ToDate([Summary 2 of Final task date completed]), ToDate([Summary of final task date completed])) &nbsp;

sharonneville · Answer

It accepted that formula, Thank you!&nbsp; However it is returning the earlier date.&nbsp; One task was completed on 10-12-16 the other was completed on 1-30-17.&nbsp; This field now shows 10-12-16.&nbsp; Any thoughts?

quickbasecoachd · Answer

Can you tell me what dates are in each of those two fields?

Forum Discussion

Comparing two workdates to return the latest date.

Related Content

Jinja Expression Comparing Now to Now+Hours

Formula-Numeric Field Returning Null Instead of 0

Pipeline Make Request - Return Make Request JSON Output into fields

Comparing Dates

Make Request JSON returning blank when only one record returned