{"id":9062,"date":"2016-07-27T11:07:41","date_gmt":"2016-07-27T11:07:41","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=9062"},"modified":"2016-07-27T11:07:41","modified_gmt":"2016-07-27T11:07:41","slug":"get-year-in-a-date-for-sage-x3-version-7","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2016\/07\/27\/get-year-in-a-date-for-sage-x3-version-7\/","title":{"rendered":"Get Year in a Date for Sage X3 version 7"},"content":{"rendered":"

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. \u201cyear\u201d. The type of result is\u00a0Integer<\/a>.<\/p>\n

year:<\/u><\/em><\/strong> year\u00a0returns the day number of a valid date, including the century.<\/p>\n

Syntax:<\/u><\/strong><\/p>\n

year(DATE_EXPR)<\/p>\n

Parameter details:<\/u><\/em><\/strong><\/p>\n

– DATE_EXPR\u00a0is an expression returning a date.<\/p>\n

Kindly refer to the below snippet of code for better understanding.<\/p>\n

\"Get<\/a><\/p>\n

 <\/p>\n

Hope this helps.<\/p>\n

About Us<\/strong><\/span><\/h5>\n

 <\/p>\n

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.<\/p>\n

Greytrix<\/a>\u00a0have some unique solutions of\u00a0Sage X3\u2019s integration with Sage CRM<\/a>,\u00a0Salesforce.com<\/a>\u00a0and\u00a0Magento eCommerce<\/a>. It also offers best-in-class\u00a0Sage X3 customization and development services<\/a>\u00a0to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n

For more information on Sage X3 Integration and Services, please contact us at\u00a0x3@greytrix.com<\/a>\u00a0.We will be glad to assist you.<\/p>\n

Other Related Blogs:<\/em><\/strong><\/p>\n

–\u00a0Fiscal Year End Process in Sage X3<\/a><\/p>\n

–\u00a0How to Know Start date of Week of any Year?<\/a><\/p>\n

–\u00a0How to handle two digit year in date<\/a><\/p>\n

–\u00a0Open a Closed Fiscal Period in Sage X3<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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. \u201cyear\u201d. The type of result is\u00a0Integer. year: year\u00a0returns the day number of a valid date, including\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[885,924,1839,1941,1942,1962],"class_list":["post-9062","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-get-year-in-a-date-for-sage-x3","tag-greytrix-blogs","tag-sage-x3-blogs","tag-sage-x3-technical","tag-sage-x3-technical-assistance","tag-sage-x3-version-7"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/9062","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=9062"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/9062\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=9062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=9062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=9062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}