General Caster: Adding Months to date & casting to date

Platform discussions monday apps & integrations
1

@rob

Need to add either 6 or 12 months (Defect Period(Months)) to a date (PC Date). Kicks out a date in 1970 :joy:

EDATE({item’s PC Date},{item’s Defect Period (Months)})

Where am I going wrong? Does EDATE not work for GC?

2

Sorry for my late reply @KristyMA.
You need to convert a date value into a valid date before making operations with it.
Here’s the formula you need to use.

TEXT(EDATE(DATEVALUE({item’s PC Date}),{item’s Defect Period (Months)}), "YYYY-MM-DD")