DATETIME_SUB

Subtracts a specified time interval from a date.

Sample usage

DATETIME_SUB(Order Date, INTERVAL 1 WEEK)

Syntax

DATETIME_SUB(datetime_expression, INTERVAL integer part)

Parameters

  • datetime_expression - a Date or a Date & Time field or expression.
  • integer - a whole numeric field or expression representing the number of parts to subtract.
  • part - the unit of time measurement to subtract. DATETIME_ADD supports the following values for part:
    • MICROSECOND: available for Date & Time fields or expressions.
    • MILLISECOND: available for Date & Time fields or expressions.
    • SECOND: available for Date & Time fields or expressions.
    • MINUTE: available for Date & Time fields or expressions.
    • HOUR: available for Date & Time fields or expressions.
    • DAY
    • WEEK. Equivalent to 7 DAYs.
    • MONTH
    • QUARTER
    • YEAR

Return data type

Date & Time

Examples

Formula Result
DATETIME_SUB(DATETIME "2008-12-25 15:30:00", INTERVAL 10 MINUTE) 2008-12-25 15:20:00
DATETIME_SUB(DATE "2008-12-25", INTERVAL 5 DAY)
2008-12-20

Notes

This function is not available for compatibility mode date types.

Special handling is required for MONTH, QUARTER, and YEAR parts when the date is at (or near) the last day of the month. If the resulting month has fewer days than the original Date or Date & Time's day, then the result day is the last day of the new month.

Related resources

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
102097
false