Get Year in a Date for Sage X3 version 7

By | July 27, 2016

You may come across the situation where you want year from particular date. Then you may probably use a format$ keyword function to get the year value. But in Sage x3 version 7 you can use another Keyword i.e. “year”. The type of result is Integer.

year: year returns the day number of a valid date, including the century.



Parameter details:

– DATE_EXPR is an expression returning a date.

Kindly refer to the below snippet of code for better understanding.

Get Year in a Date for Sage x3


Hope this helps.

About Us


Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix have some unique solutions of Sage X3’s integration with Sage and Magento eCommerce. It also offers best-in-class Sage X3 customization and development services to Sage business partners, end users, and Sage PSG worldwide.

For more information on Sage X3 Integration and Services, please contact us at .We will be glad to assist you.

Other Related Blogs:

– Fiscal Year End Process in Sage X3

– How to Know Start date of Week of any Year?

– How to handle two digit year in date

– Open a Closed Fiscal Period in Sage X3