AddToDateTime

Mon 01 January 2018

Syntax

AddToDateTime(datetime, years,  months, days, hours, minutes, seconds)

Description

Use the AddToDateTime function to add the specified number of years, months, days, hours, seconds, and minutes to the datetime provided. You can subtract from datetimes by passing the function negative numbers.

Parameters

Field or Control

Definition

datetime

The initial Datetime value.

years

An integer representing the number of years to add to datetime .

months

An integer representing the number of months to add to datetime .

days

An integer representing the number of days to add to datetime .

hours

An integer representing the number of hours to add to datetime .

minutes

An integer representing the number of minutes to add to datetime .

seconds

An integer representing the number of seconds to add to datetime .

Returns

A Datetime value equal to the original date plus the number of years, months, days, hours, minutes, and seconds passed to the function.