30 MIN DISCOVERY CALL
30 DAY FREE TRIAL
Home
(current)
Features
Solutions
SQL Database Solution
Dynamics 365 Solution
SharePoint Solution
Salesforce Solution
Active Directory Solution
Podio Solution
Pricing
Download
Blog
Help
Documentation
Knowledge base
Sign In
Functions
Documentation
Data Sync
Functions
YEAR
DateTime Functions
DATEADD
DATEDIFF
DATESTR
DATETIME
DATEVALUE
DAY
HOUR
ISO8601DATE
ISO8601DATETIME
MILLISECOND
MINUTE
MONTH
NOW
NETWORKDAYS
SECOND
TIMESTR
TODAY
UTCNOW
WEEKDAY
WEEKNUM
YEAR
YEAR
Returns the year value of a DateTime.
Syntax
int? YEAR(DateTime? value)