Calculated date using a number field

[Huntscape-Ops]

Using a calculated field, is it possible to have a date field + number field = date field?

Invoice send date + Term Length (number field) = Invoice due date

add_time([properties.invoice_send_date], [properties.term_length], 'day') is giving me a huge number and not a date

[Huntscape-Ops]

This is what I have and am running into the issue of no date coming out

[karstenkoehler · Accepted solution]

@Huntscape-Ops please see my previous note on the output type, this needs to be set as date. You have it set as number.

The formula is as simple as:

date property + number property

(Keeping in mind that you need to multiply the number property with whatever the equivalent of milliseconds to your time unit is.)

[karstenkoehler]

Hi @Huntscape-Ops,

Are you referring to a calculation property?

If so, yes, as long as you convert the number property into milliseconds and set the output type to "Date". (Calculated property type = Custom equation)

Can you share a screenshot of your configuration?

Best regards