Cast Invalid Error

All the working ones return value in interval day to second while month() and year() return value in interval year to month. One way to make this work is by converting data returned from month() and year() into interval of day to second. You can use the function tointervalds() to achieve this.

{
  /* All these worked */
  now() + second() * 62,
  now() + minute() * 5,
  now() + hour() * 5,
  now() + day() * 5,
  
  now() + tointervalds(month())*5 ,
  now() + tointervalds(year())*5 
}

All the working ones return value in interval day to second while month() and year() return value in interval year to month. One way to make this work is by converting data returned from month() and year() into interval of day to second. You can use the function tointervalds() to achieve this.

{
  /* All these worked */
  now() + second() * 62,
  now() + minute() * 5,
  now() + hour() * 5,
  now() + day() * 5,
  
  now() + tointervalds(month())*5 ,
  now() + tointervalds(year())*5 
}

Hi Harsha

now() + tointervalds(month())*5

didn't work, it was still adding 5 days instead of 5 months.

In order to use tointervalds() function here, you need to calculate the no of days in upcoming 5 (or required number of) months, and then replace 5 with that value. now() returns date time and it only can add/subtract in days so you need to convert year/month into days so that addition/subtraction can happen with now(). 

As an alternative, if your usecase is to add a specific number of months/years to a date I suggest you to take a look at plugin Date and Time Utilities in the app market. Functins addmonths() & addyears() can help you here!

{
  addseconds(now(), 62),
  addminutes(now(), 5),
  addhours(now(), 5),
  adddays(now(), 5),
  addmonths(now(), 5),
  addyears(now(), 5)
}