Liquid Studio 2021
Data Mapping / Data Mapper Functions / By Category / Date Time / DateAdd
In This Topic
    DateAdd
    In This Topic

    Function Name
    DateAdd
    Category
    DateTime
    Icon
    DateAdd
    Description
    Adds or subtracts a number of days/hours/minutes/seconds from an Date/Datetime
    Inputs
    Date The Date/DateTime/Time to add to
    Days The number of days to add (can be a negative number)
    Hours The number of hours to add (can be a negative number)
    Minutes The number of minutes to add (can be a negative number)
    Seconds The number of seconds to add (can be a negative number)
    Milliseconds The number of milliseconds to add (can be a negative number)
    Outputs
    Result A Date time with the days/hours/minutes/seconds added to it
    Properties
    None -

    Usage

    The Data Mapper DateAdd function takes an existing Date/DateTime/Time value and adds on a number of days/hours/minutes/seconds, the resulting DateTime is then returned.

    In order to subtract, use negative number for days/hours/minutes/seconds.

    See Also