Time Function in Anaplan

g.mahesh

Hi Team,

 

Need your help with the below requirement,

 

We are using 5 line items with a date Format. 

 

	Line Items
Employee	A	B	C	D	E
Mahesh	12-02-2021	01-01-2021	10-01-2021	12-12-2020	10-01-2021

 

Based on the available Dates, we want to find the earliest date through the formula. how we can achieve this Anaplan?

 

In the above example, the earliest date is 12-02-2021.

 

Thanks,

Uma

g.mahesh

Thanks Rishab.

 

We need to use MAX function here.