Enterprise & Sell

Enterprise & Sell Answers & Best Practices Date not older than another date field

Click here to join this group and curate your SugarClub experience.

Details about this thread

State Not Answered
+1 person also asked this people also asked this
Replies 8 replies
Subscribers 309 subscribers
Views 2697 views
Users 0 members are here

Related content from around SugarClub

Date not older than another date field

Lena Andersson over 4 years ago

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

0 Lena Andersson over 4 years ago

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?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Lena Andersson over 4 years ago

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?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 André Lopes over 4 years ago in reply to Lena Andersson

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

André Lopes
Lampada Global

Skype: andre.lampada
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel