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?
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?
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
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 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.