Documentation Center

  • Trials
  • Product Updates

year

Year of date

Syntax

Year = year(Date)
Year = year(Date, F)

Description

Year = year(Date) returns the year of a serial date number or a date string.

Year = year(Date, F) returns the year, given a serial date number or date string, in a specified date format.

Examples

Year = year(731798.776)

or

Year = year('05-Aug-2003')

returns

 Year =

        2003

You can also use the F argument to designate a country-specific date format:

Year = year('2003/08/05','yyyy/mm/dd')
Year =

       2003.00

See Also

| | |

Was this topic helpful?