Details about this thread
  • State Verified Answer
  • Replies 4 replies
  • Subscribers 322 subscribers
  • Views 1268 views
  • Users 0 members are here

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. 

  • 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
  • 0

    Thanks for the explanation, it looks like I didn't use the right formula. 

    The closing date l($icc_closing_date) is always manually added by my colleagues. The first payment date field ($termin_1_rate_c) should automatically take the closing date as the date for the first payment.

    So the first payment date field should have some kind of formula to take the value from the closing date field. 

    Best

  • 0 in reply to Jaqueline Bargmann

    Thank you for clarifying the request.

    The formula is the simplest possible!

    sugarLogic formula for termin_1_rate_c:

    $icc_closing_date

     

    Definitely it is only that!!!!

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    Oh well, that was really simple  I thought formulas always needed some kind of addition. 

    Thank you for your quick help!