month(exp_date)<\/em><\/strong><\/p>\n month$(exp_date)<\/em><\/strong><\/p>\n month$(exp_num)<\/em><\/strong><\/p>\n Where,<\/p>\n exp_date<\/em><\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : date type expression<\/p>\n exp_num \u00a0 \u00a0 \u00a0 \u00a0\u00a0<\/em><\/strong>: <\/strong>numerical expression<\/p>\n month$ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0: <\/strong>extracts the name of the month for a valid date.<\/p>\n If the argument is numerical, it is a month number, calculated with modulo 12 (1 for “January”, etc.).<\/p>\n The result is a Char type.<\/p>\n You can pass either the date or number of a month as an argument to this function.<\/p>\n Refer the below screenshots better understanding.<\/p>\n Here, the date is passed as an argument to month$() function.<\/p>\n Here, the number of a month is passed as an argument to month$() function.<\/p>\n Output for above two snippets is:<\/p>\n Hope this blog helps!<\/strong> 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. Sage X3 provides an inbuilt function to retrieve the number and name of month from the particular date. Following are the functions you need to write for the same. To retrieve number of month from given date: month(exp_date) To retrieve name of month from given date or given number of month: month$(exp_date) month$(exp_num) Where, exp_date\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\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":[1303,1304,1839,1942,1945],"class_list":["post-8644","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-month-name","tag-month-name-given-date","tag-sage-x3-blogs","tag-sage-x3-technical-assistance","tag-sage-x3-technical-blogs"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/8644","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=8644"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/8644\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=8644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=8644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=8644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Sage](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2016\/05\/Sage-X3-Month-Name.png\")
<\/a><\/p>\n<\/a><\/p>\n\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n
\n
\nAbout Us<\/strong><\/p>\n
\n
\nOther Related Blogs:<\/em><\/strong><\/p>\n\n