Description

 

The DT_Year() function returns the year from a given date string.

 

Syntax

 

DT_Year(sDate) AS NUMBER

 

Returns

 

Returns AS NUMBER

  The year.

 

Parameters

 

sDate AS STRING

  The date string, if empty the functions returns the current year.

 

Remarks

 

The value of sDate parameter should be like “mm-dd-yy” or “mm-dd-yyyy”.

If the the year is two digits only the calculation is done using the century (default %DT_DATE_CENTURY).

Restrictions

 

 

See also

 

  DT_Month, DT_Day

 

Examples

 

MSGBOX 0, DT_Year("06-13-05")  ' results 2005