Forum Discussion
Solved
Find most recent date from multiple columns
I have a worklflow which assigns a phase (Phase A) to multiple people simultaneously. Each person may approve the workflow on a different date. I need to calculate the days between the last approva...
ddownard , Try a new column like
Switch( True(),
[Supervisor Date] > [Engineer Date] && [Supervisor Date] > [Writer Date], [Supervisor Date],
[Engineer Date] > [Writer Date] ,[Engineer Date] ,
[Writer Date]
)
ddownard , Try a new column like
Switch( True(),
[Supervisor Date] > [Engineer Date] && [Supervisor Date] > [Writer Date], [Supervisor Date],
[Engineer Date] > [Writer Date] ,[Engineer Date] ,
[Writer Date]
)
amitchandak , can you tell me how to change your code to include three additional columns?