Creator Help

edate Function

This topic describes the syntax and usage of the EDATE function in Zoho Creator .

Description

Returns the date that is the indicated number of months before or after the start date. A positive value for months yields a future date; a negative value yields a past date. Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.ue updated each time you open the form.

Syntax

edate(<start_date>, <months>)

The edate function syntax has the following arguments.

start_date - A date in date/date-time format that represents the start date.

months - An integer that represents the number of months after or before the start_date.  A positive value for months yields a future date; a negative value yields a past date.

Note: This function is supported only in free-flow scripting mode of Script Builder. 

Return Value

A date (datetime) as per the date format specified in your application settings page.

Example

   

   edate([today,,3);           //returns November 15, 2013, if the today function returns a date value August 15, 2013.
   edate(sale_date, 1);      //returns February 01, 2013, if sale_date is January 01, 2013
   edate(sale_date, -1);    //returns December 01, 2012, if sale_date is January 01, 2013.

Top