%DateDiff meta-SQL element

Syntax

%DateDiff(date_from, date_to)

Description

The %DateDiff meta-SQL function returns an integer representing the difference between two dates in number of days. For example: diff = date_to - date_from

Example

%DateDiff(%DateIn('1966-06-30'), %DateIn('1997-01-01'))

%DateDiff( date1_column, date2_column)

%DateDiff( %DateAdd(date1_column, 30), date2_column)

The following usage is illegal (always use %Datein for inputting date literals):

%DateDiff('1996-06-30', '1997-01-01') /* should use %DateIn for inputting date literals */