Date not older than another date field

Thank you Chris! I did a try with your formula but I do wrong somewhere 

ifElse(or(greaterThan(daysUntil($plannedstartdate_c),daysUntil($date_closed)),equal(daysUntil($plannedstartdate_c),daysUntil($date_closed))),"plannedstartdate_c","")

I have tried in the last section both with plannedstartdate and plannedstartdate_c

Can you see where it goes wrong?

The formula seems to be ok, which kind of field did you create and subject of such formula?

Both fields are date fields- nots datetime.

It is in the module Opportunity

Best regards

I mean: did you configure such formula inside which field? What is the type of such field?

I mean: did you configure such formula inside which field? What is the type of such field?

I did the formula under the Field planned startdate

Its a calculated field

Hämta Outlook för iOS<https://aka.ms/o0ukef>

Hi Lena,

If I am understanding correctly, the formula referencing plannedstartdate_c is defined in the field of the same name. If that is accurate, a formula cannot be self-referencing. In my example, I have the following:

date_closed - Stock date field

start_date_c - Custom date field; non-calculated and defined by the user

date_validator_c - Custom, required text field; calculated with the formula I referenced

If my understanding of your configuration is inaccurate, please provide more details about what is not working as expected with screenshots if possible. Do you receive an error when trying to save the formula? Does the validation not work when saving the opportunity?

One final note is that I am unable to view your Sugar instance. In general, I recommend against publicizing identifiable details about your instance such as the URL as this is a public community.