Year - Built-in Date & Time Function¶

Purpose¶

Year returns the year from a datetime expression.

Syntax¶

Year(Datetime)

Arguments¶

Returns¶

Integer

See also¶

• Date
• DateAdd
• DateDiff
• DatePart
• DateValue
• DateSerial
• Day
• Hour
• InAgedToDays
• InLast4WeeksToSunday
• InLast7Days
• InLastFullMonth
• InLastFullWeek
• InLastYearMTD
• InLastYearYTD
• InLeapYear
• Minute
• Month
• MonthName
• Now
• Second
• Time
• TimeSerial
• TimeValue
• WeekAgo
• Weekday
• WeekdayName

Example¶

Dim dtSys

// the following returns the current year
Let dtSys = Now()

Return Year(dtSys)

// the following returns the number of years between two dates
Return (Year(Now()) – Year({Orderheader.Order_Date}))

Notes¶

• When datetime cannot be converted to a datetime value, a runtime error is generated.
• When date is passed as a string, your PC's regional settings are used for the conversion to datetime. If that fails, you get a runtime error.