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)

Products

Data Synchronisation Studio
Ouvvi Automation Server

Integrations

SQL Database
Dynamics 365
SharePoint
Salesforce
Active Directory
Podio

Store

Pricing
Global Resellers

Help & Support

My Account
Online Documentation

Get in touch

+44 (0) 1424 863450
hello@simego.com
HelpDesk
Address
Simego Ltd, The Brambles,
Nuneaton Road, Nuneaton
CV10 0SR, UK

© 2008-2021 Simego Ltd | Company No: 06571349 | VAT No: GB934401838

Terms
Data Protection Policy
Cookie Policy