JulieMeeker

4 years agoQrew Cadet

# Calculate a future date in a pipeline

I am getting this error when I use the same formula that worked in a formula field

Validation error: Invalid date/time value: 2021-07-13 00:00:00+00:00+ Days(14.0)

This is my formula {{a.complete_date}}+ Days({{b.maintenance_interval}}) complete_date is defined as a Date field type and not date/time.

Is there a function that strips the time off because it appears that is what is causing the error?

------------------------------

Julie Meeker

------------------------------

Validation error: Invalid date/time value: 2021-07-13 00:00:00+00:00+ Days(14.0)

This is my formula {{a.complete_date}}+ Days({{b.maintenance_interval}}) complete_date is defined as a Date field type and not date/time.

Is there a function that strips the time off because it appears that is what is causing the error?

------------------------------

Julie Meeker

------------------------------