DateDiff

Overview

Returns the difference between two dates.

Syntax

DateDiff(1, 2, 3)

Function Properties

OrdinalTypeDescription
1DateRequiredStarting date for comparison using either MM/dd/yyyy or YYYY-MM-DD format
2DateRequiredDate to subtract from starting date using either MM/dd/yyyy or YYYY-MM-DD format
3stringRequiredUnit of time of the difference. Valid values include Y, M, D, H, or MI

Usage

System returns: 1