{"id":9290,"date":"2016-09-21T08:32:04","date_gmt":"2016-09-21T08:32:04","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=9290"},"modified":"2016-09-21T08:32:04","modified_gmt":"2016-09-21T08:32:04","slug":"how-to-find-the-last-date-of-any-month","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2016\/09\/21\/how-to-find-the-last-date-of-any-month\/","title":{"rendered":"How to Find the Last Date of Any Month"},"content":{"rendered":"

You may come across the situation where you have to find the last date of any month whether it is 30, 31, 28 or 29. To do so we can take help of EOMONTH function.<\/p>\n

Syntax:<\/p>\n

eomonth(DATE_EXPR)<\/p>\n

DATE_EXPR is an expression returning a date value.<\/p>\n

Consider following example where we have to find out the last date of month February.<\/p>\n

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

Above code will give as an output as<\/p>\n

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

 <\/p>\n

Hope this helps!<\/p>\n

About Us<\/strong><\/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, 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

–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Get Year in a Date for Sage X3 version 7<\/a><\/p>\n

–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Know Month Name from the Given Date<\/a><\/p>\n

–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 How to get number of day and name from date<\/a><\/p>\n

–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 How to Sort Array in Ascending and Descending Order<\/a><\/p>\n

–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 How to Delete Element from an Array?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

You may come across the situation where you have to find the last date of any month whether it is 30, 31, 28 or 29. To do so we can take help of EOMONTH function. Syntax: eomonth(DATE_EXPR) DATE_EXPR is an expression returning a date value. Consider following example where we have to find out the\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":[827,918,1134,1774,1780,1901,1938,1942],"class_list":["post-9290","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-find-date-of-any-month","tag-greytrix","tag-last-date-of-any-month","tag-sage-erp-and-sage-crm","tag-sage-erp-x3","tag-sage-x3-issues","tag-sage-x3-techhnical","tag-sage-x3-technical-assistance"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/9290","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=9290"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/9290\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=9290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=9290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=9290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}