What is the syntax to return the year of a date?

Year(date)
‘examples
MsgBox (Year("2074/3/18")) 'returns 2074
MsgBox (Year("2074-3-18")) 'returns 2074
MsgBox (Year(#3/18/2074#)) 'returns 2074

 

Advertisements