DATES

Returns a date string in yy-mm-dd format.

Syntax

DATES(Year, Month, Day)

Year, Month, and Day are integers. Values entered for Year 60 through 99 correspond to the years 1960 through 1999. Values entered for Year from 00 through 59 correspond to the years 2000 through 2059. Month must be an integer between 1 and 12. Day must be an integer between 1 and 31.

Example

This example returns '08-02-10':

DATES(08, 2, 10)