_ymdint_between

Returns a number representing the difference between "timestamp_expression1" and "timestamp_expression2". This value has the form YYMMDD, where YY represents the number of years, MM represents the number of months, and DD represents the number of days.

Syntax

_ymdint_between ( timestamp_expression1 , timestamp_expression2 )

Example

_ymdint_between ( [Query1].[Date (close date)] , [Query1].[Date (ship 
date)] ), where [Query1].[Date (close date)] is February 20, 2004, 
and [Query1].[Date (ship date)] is January 19, 2004.

Result

101, where 1 is the number of months and 01 is the number of days.