Field formula

[djd]

I am using Project 2000. I have a set of three dates and need to
automatically choose the earliest date of the three. Is there a minimum
value formula I can use to accomplish this?

Thanks for your help
Dave

 

[Gérard Ducouret]

Hi Dave,
AFAIK, there is no Min function, but try this formula :

IIf([Date1]<[Date2] And [Date1]<[Date2],[Date1],IIf([Date2]<[Date1] And
[Date2]<[Date3],[Date2],[Date3]))

 

[djd]

Thanks for your help. It helped me out. After a test run I made a slight
change for a typo in the first statement:

IIf([Date1]<[Date2] And [Date1]<[Date3] ... (instead of date 2 again)

and now it runs perfect

Thanks again
Dave

Hi Dave,
AFAIK, there is no Min function, but try this formula :

IIf([Date1]<[Date2] And [Date1]<[Date2],[Date1],IIf([Date2]<[Date1] And
[Date2]<[Date3],[Date2],[Date3]))
--
Gérard Ducouret [Project MVP]

I am using Project 2000. I have a set of three dates and need to
automatically choose the earliest date of the three. Is there a minimum
value formula I can use to accomplish this?

Thanks for your help
Dave