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

Misbah

@g.mahesh 

 

Try using MIN function like MIN(A,B,C,D,E)

 

Hope that helps

Misbah

 

g.mahesh

Thanks Rishab.

 

We need to use MAX function here.

Misbah

@g.mahesh 

 

I thought you were looking for earliest date. Anyway glad that MAX worked

 

By the way the name is Misbah.