Versions Compared

Version Old Version 6 New Version 7
Changes made by

Eleanor Brodie

Fiona Sargeant (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt
hiddentrue

dateAdd(date, dateField, dateValue) Add or subtract time to/from a date.

Function: dateAdd()

Add or subtract time to /or from a date.

Syntax

dateAdd(date,dateField,dateValue)

Argument
Type
Description
date
Date
The original
date/timedateFieldDate Field
date or date-time. For the current date-time use the attribute function now().See Date-Time Functions for details about the arguments.
dateFieldThe part of the date-time to be
added subtracted (e.g. days or seconds)
changed.
dateValue
Date ValueThe number of (e.g.) days or seconds to be added or subtracted (negative value). This must be a whole number. If it is not an integer it will be
A whole number to add to the date-time. To subtract a number, use a negative value.
Non-integer values are rounded down and any decimal places will be ignored.

Examples

dateAdd(now(),_MONTH, -3)

Returns a date and time value three months before the current date and time.

See Also

...

Excerpt
hiddentrue

dateAdd(date, dateField, dateValue)   Add or subtract time to/from a date.