Time Function in Anaplan

g.mahesh · February 2021

Hi Team,

Need your help with the below requirement,

We are using 5 line items with a date Format.

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 · February 2021

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

Hope that helps

Misbah

g.mahesh · February 2021

Thanks Rishab.

We need to use MAX function here.

Misbah · February 2021

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

By the way the name is Misbah.

Best Answer