Formula: Ontime/late

Gaetano_B

Hi All, Happy Friday.

I'm trying to create a column (Completion Delta) which shows me whether a milestone was 'On Time' or 'Late' based on a date, as per example below.

Any Suggestions?

Target Completion Date	Actual Completion Date	Completion Delta
18/10/2020	19/10/2020	Late
18/10/2020	18/10/2020	On Time
18/10/2020	17/10/2020	On Time

RolandSchubert

Hi @Gaetano_B ,

a formula using DateTime functions should do it:

IF DateTimeDiff(DateTimeParse([Target Completion Date], '%d/%m/%Y'), DateTimeParse([Actual Completion Date], '%d/%m/%Y'), 'days') >= 0 THEN
'On Time'
ELSE
'Late'
ENDIF

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland

DateTimeCompare.yxmd