Time Function in Anaplan

g.mahesh
Occasional Contributor

Time Function in Anaplan

Hi Team,

 

Need your help with the below requirement,

 

We are using 5 line items with a date Format. 

 

 Line Items
EmployeeABCDE
Mahesh12-02-202101-01-202110-01-202112-12-202010-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

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: Time Function in Anaplan

@g.mahesh 

 

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

 

Hope that helps

Misbah

 

View solution in original post

3 REPLIES 3
Misbah
Moderator

Re: Time Function in Anaplan

@g.mahesh 

 

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

 

Hope that helps

Misbah

 

View solution in original post

g.mahesh
Occasional Contributor

Re: Time Function in Anaplan

Thanks Rishab.

 

We need to use MAX function here.

Misbah
Moderator

Re: Time Function in Anaplan

@g.mahesh 

 

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

 

By the way the name is Misbah.