Help Build a Date Format Formula for Calculated

, ,
1

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?

Thank you,
Donna

2

Hi @dlively,

Since the DATE_FORMAT function returns a string type value, please switch the calculated field to a Text field for specifying the formula.

I was able to recreate the desired outcome with the following formula;

DATE_FORMAT(cbc_pmt_recd + (60*60*24*45), "YYYY-MM-dd", "UTC")

Could you try this and see if it works for you?
I hope this answers your question.

3

Thank you very much. That worked!