The parameter that specifies on which part of the date to calculate the difference. For more information, see the "Remarks" section later in this topic.
The beginning date for the calculation. The startdate argument is an expression that returns a datetime value or a Unicode character string in a date format.
If you specify only the last two digits of the year, values less than or equal to the last two digits of the value of the two digit year cutoff configuration option are in the same century as the cutoff year. Values greater than the last two digits of the value of this option are in the century that comes before the cutoff year. For example, if the two digit year cutoff is 2049 (the default value), the '49' is interpreted as 2049 and '50' is interpreted as 1950. To avoid ambiguity, use four-digit years.
For more information about how to specify dates, see datetime in Data Types.
The ending date for the calculation. The enddate argument is an expression that returns a datetime value or a Unicode character string in a date format.
The following table lists the datepart options and abbreviations recognized by SQL Server Compact 3.5.