Calculating the Date N Years Later from a Date in "Date" / "Date and Time" Field

Article Number:040748

You can create a formula that specifies time in seconds.
In Kintone, the values in the date, time, and date and time fields are treated as UNIX time. That means the dates and the times are treated in seconds. Therefore, you need to specify your formula in seconds as well. For example, enter "60" to indicate one minute. Enter "3600" or "60*60" to indicate one hour, and enter "86400" or "60*60*24" to indicate one day.

Example of Date and Time Field

Place a Date and Time field and a Calculated field, and specify a formula shown below in the Calculated field.

  • Formula to calculate N years later date and time: Date_and_Time+(N*60*60*24*365)

  • Formula to calculate N days later date and time: Date_and_Time+(N*60*60*24)

  • Formula to calculate N hours later date and time: Date_and_Time+(N*60*60)

  • Formula to calculate N minutes later date and time: Date_and_Time+(N*60)