{"id":1116,"date":"2023-03-09T06:11:27","date_gmt":"2023-03-09T06:11:27","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?p=1116"},"modified":"2024-12-03T06:06:00","modified_gmt":"2024-12-03T06:06:00","slug":"date-formats-in-acumatica","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/","title":{"rendered":"Date Formats in Acumatica"},"content":{"rendered":"\n<p>In this blog we will learn how to add various date formats in<strong> <\/strong>Acumatica systems for print Reports and export data.<\/p>\n\n\n\n<p>We receive unstructured data from a number of companies. Columns with date information have various formats that change from week to week. (example, mm-dd-yy, mm\/dd\/yyyy, dd-mmm-yy, yyyy\/mm\/dd, etc.)<\/p>\n\n\n\n<p>For this date format mm\/dd\/yyyy we can pass this function =Format(&#8216;{0:MM\/dd\/yyyy}'[Fieldname])<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/01-MonthDateYear-format-1.png\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/01-MonthDateYear-format-1.png\" alt=\"Acumatica MonthDateYear format\"><\/a><\/center><\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code><center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/02-Result-DateFormat.png\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/02-Result-DateFormat.png\" alt=\"02 Result DateFormat\"><\/a><\/center><\/code><\/pre>\n\n\n\n<p>We can also change the rest of the formats according to this function We can use &#8211; instead of \/ for change format.<\/p>\n\n\n\n<p>For this date format mm-dd-yyyy we can pass this function<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>=Format(&#8216;{0:MM-dd-yyyy}'[Fieldname])<\/p>\n<\/blockquote>\n\n\n\n<p>If we want to extract time from date time format then we can use PadLeft function to remove time pads the beginning of the returned string. This means that, when used with right-to-left languages, it pads the right portion of the string. If the PadLeft method pads the current instance with white-space characters, this method does not modify the value of the current instance.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>=PadLeft(Day([Fieldname]),2,&#8217;0&#8242;) + &#8221; + PadLeft(Month ([Fieldname]),2,&#8217;0&#8242;) + &#8221; + Right(Year([Fieldname]),2)<\/p>\n<\/blockquote>\n\n\n\n<p>In <strong><a href=\"https:\/\/www.greytrix.com\/acumatica\/\" target=\"_blank\" rel=\"noreferrer noopener\">Acumatica<\/a> <\/strong>Cloud ERP, we create a calculated column that shows a date field formatted as Year, Quarter. i.e. July 21, 2021 to show &#8220;2021, Q4&#8221;<\/p>\n\n\n\n<p>use the expression editor in the \u201cData Field\u201d with the Switch formula.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/07-Date-field-formatted-as-Year.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/07-Date-field-formatted-as-Year.png\" alt=\"07 Date field formatted as Year\"><\/a><\/center><\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code><center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/08-Result-DateField-Formatted-as-year-1.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/08-Result-DateField-Formatted-as-year-1.png\" alt=\"08 Result DateField Formatted as year\"><\/a><\/center><\/code><\/pre>\n\n\n\n<p>Hope this blog will help you to understand various date formats in <a href=\"https:\/\/www.greytrix.com\/acumatica-cloud-erp\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Acumatica.<\/strong><\/a><\/p>\n\n\n","protected":false},"excerpt":{"rendered":"<p>In this blog we will learn how to add various date formats in Acumatica systems for print Reports and export data. We receive unstructured data from a number of companies. Columns with date information have various formats that change from week to week. (example, mm-dd-yy, mm\/dd\/yyyy, dd-mmm-yy, yyyy\/mm\/dd, etc.) For this date format mm\/dd\/yyyy we\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":2550,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[146,3,14],"tags":[4,159,16,248],"class_list":["post-1116","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-acumatica","category-acumatica-erp","category-acumatica-services","tag-acumatica","tag-acumatica-customization","tag-acumatica-erp","tag-erp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Acumatica Date Formats: Understanding Options<\/title>\n<meta name=\"description\" content=\"Discover date formats used in Acumatica ERP software. Learn how to configure and customize date settings efficiently for your business needs\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Acumatica Date Formats: Understanding Options\" \/>\n<meta property=\"og:description\" content=\"Discover date formats used in Acumatica ERP software. Learn how to configure and customize date settings efficiently for your business needs\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/\" \/>\n<meta property=\"og:site_name\" content=\"Acumatica \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-09T06:11:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-03T06:06:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/02-Result-DateFormat-2-e1721627811695.png\" \/>\n\t<meta property=\"og:image:width\" content=\"499\" \/>\n\t<meta property=\"og:image:height\" content=\"232\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/\",\"name\":\"Acumatica Date Formats: Understanding Options\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/02-Result-DateFormat-2-e1721627811695.png\",\"datePublished\":\"2023-03-09T06:11:27+00:00\",\"dateModified\":\"2024-12-03T06:06:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec\"},\"description\":\"Discover date formats used in Acumatica ERP software. Learn how to configure and customize date settings efficiently for your business needs\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/02-Result-DateFormat-2-e1721627811695.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/02-Result-DateFormat-2-e1721627811695.png\",\"width\":499,\"height\":232,\"caption\":\"Date Format Acumatica\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Date Formats in Acumatica\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\",\"name\":\"Acumatica \u2013 Tips, Tricks and Components\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec\",\"name\":\"greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Acumatica Date Formats: Understanding Options","description":"Discover date formats used in Acumatica ERP software. Learn how to configure and customize date settings efficiently for your business needs","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/","og_locale":"en_US","og_type":"article","og_title":"Acumatica Date Formats: Understanding Options","og_description":"Discover date formats used in Acumatica ERP software. Learn how to configure and customize date settings efficiently for your business needs","og_url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/","og_site_name":"Acumatica \u2013 Tips, Tricks and Components","article_published_time":"2023-03-09T06:11:27+00:00","article_modified_time":"2024-12-03T06:06:00+00:00","og_image":[{"width":499,"height":232,"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/02-Result-DateFormat-2-e1721627811695.png","type":"image\/png"}],"author":"greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greytrix","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/","name":"Acumatica Date Formats: Understanding Options","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/02-Result-DateFormat-2-e1721627811695.png","datePublished":"2023-03-09T06:11:27+00:00","dateModified":"2024-12-03T06:06:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec"},"description":"Discover date formats used in Acumatica ERP software. Learn how to configure and customize date settings efficiently for your business needs","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/02-Result-DateFormat-2-e1721627811695.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/03\/02-Result-DateFormat-2-e1721627811695.png","width":499,"height":232,"caption":"Date Format Acumatica"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/03\/09\/date-formats-in-acumatica\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/acumatica\/"},{"@type":"ListItem","position":2,"name":"Date Formats in Acumatica"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/","name":"Acumatica \u2013 Tips, Tricks and Components","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec","name":"greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/1116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/comments?post=1116"}],"version-history":[{"count":11,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/1116\/revisions"}],"predecessor-version":[{"id":3061,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/1116\/revisions\/3061"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/media\/2550"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/media?parent=1116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/categories?post=1116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/tags?post=1116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}