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
------------------------------