Details about this thread
  • State Verified Answer
  • Replies 4 replies
  • Subscribers 293 subscribers
  • Views 704 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

    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

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

Children