I have a date field named
cbc_pmt_recd to record the date that payment was received.
I am trying to create a formula to give me the date 45 days after the payment date.
The below is what I have, but it is not working properly.
DATE_FORMAT(cbc_pmt_recd + 86400*45, "YYYY/MM/dd", "UTC")
If I enter Nov 9, 2022, into the
cbc_pmt_recd field, the calculated field returns #CONVERT!
What am I doing wrong?