Date not older than another date field

I have 2 date field in my opportunties - 

Expected Close Date

and

Start Date

I would like that you cant save the opportunity if Start date is the same or older than Expected Close Date. How do I write that formula?

Parents Reply
  • 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.

Children
No Data