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
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
@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.)
