Details about this thread
  • State Verified Answer
  • Replies 4 replies
  • Subscribers 293 subscribers
  • Views 709 views
  • Users 0 members are here
Related content from around SugarClub

Two date fields should have the same value

Jaqueline Bargmann

Hi Community,

I seem to be struggling with a simple problem. My goal is to create a formula so that the first date field equals another field and the second date field is automatically populated with the other's date. The closing date should be the date for the first payment. 

This is what I have tried so far: 

equal($icc_closing_date)

date(equal($icc_closing_date,$termin_1_rate_c)) 

equal(date($icc_closing_date,date($termin_1_rate_c)))

It always gives me some kind of error messages and I'm not an expert in this field so I can't figure out what I have to change. 

Maybe it's not possible as a formula but it needs to be a workflow? 

Thanks in advance. 

Parents
  • 0

    Initially you need to understand the nature of each formula.

    equal: is a boolean formula (returns true or false) and requires two arguments. It compares both parameters and returns true if they are equals or false if not.

    date: is a date formula (returns a date object) and requires a string parameter. It tries to convert such string into a date object, which can be populated into a date field.

    Additionally can you kindly explain which field has to be populated with which formula? (you can even describe the formula in your own words instead of regular sugarLogic formulas).

    Regards

    André Lopes
    Lampada Global
    Skype: andre.lampada
Reply
  • 0

    Initially you need to understand the nature of each formula.

    equal: is a boolean formula (returns true or false) and requires two arguments. It compares both parameters and returns true if they are equals or false if not.

    date: is a date formula (returns a date object) and requires a string parameter. It tries to convert such string into a date object, which can be populated into a date field.

    Additionally can you kindly explain which field has to be populated with which formula? (you can even describe the formula in your own words instead of regular sugarLogic formulas).

    Regards

    André Lopes
    Lampada Global
    Skype: andre.lampada
Children
No Data