edate

    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.

    Share this post : FacebookTwitter

    Still can't find what you're looking for?

    Write to us: support@zohocreator.com