{"id":1262,"date":"2023-04-06T09:06:24","date_gmt":"2023-04-06T09:06:24","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?p=1262"},"modified":"2024-12-02T05:53:13","modified_gmt":"2024-12-02T05:53:13","slug":"various-date-function-in-acumatica","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/","title":{"rendered":"Various Date Function in Acumatica"},"content":{"rendered":"\n<p><strong><u>Introduction:<\/u><\/strong>&nbsp;<\/p>\n\n\n\n<p>Acumatica supports various date functions. In this blog, we will learn how to use various date Functions of Acumatica that can be used while printing Reports and Displaying GI.<\/p>\n\n\n\n<p>In this example we shall demonstrate the date functions usage in Generic Inquiry.<\/p>\n\n\n\n<p><strong>DateDiff function:-<\/strong><\/p>\n\n\n\n<p>The DATEDIFF() function returns the difference between two dates. To do this, we using the Soorder table, and CreatedDate Time and orderdate in the Results tab. added another row with the formula =DateDiff(&#8216;d&#8217;,[SOOrder.OrderDate],[SOOrder.DueDate])<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/04\/1.DateDiffrence-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\/04\/1.DateDiffrence-1.png\n\" alt=\"1.DateDiffrence-1.png\"><\/a><\/center><\/code><\/pre>\n\n\n\n<p><strong>DateAdd function&nbsp;:-<\/strong><\/p>\n\n\n\n<p>The DATEADD function returns a date with the addition of a specified part of the date. In this we are adding 5 days to the Order date.<\/p>\n\n\n\n<p>formula =DateAdd([SOOrder.OrderDate],&#8217;d&#8217; ,7)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/04\/2.DateAdd.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\/04\/2.DateAdd.png\n\" alt=\"2.DateAdd.png\"><\/a><\/center><\/code><\/pre>\n\n\n\n<p><strong>DayOfWeek function&nbsp;:-<\/strong><\/p>\n\n\n\n<p>The DateOfWeek function returns a number of weeks of the date.<\/p>\n\n\n\n<p>When we run the DayofWeek function on a Sunday = 1 and Saturday = 7.<\/p>\n\n\n\n<p>formula = DayOfWeek( [SOOrder.OrderDate])<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/04\/3.-Day-of-week.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\/04\/3.-Day-of-week.png\n\" alt=\"3.-Day-of-week.png\"><\/a><\/center><\/code><\/pre>\n\n\n\n<p>And finally the result is shown is below when you view GI.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/04\/4.Result-Function.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\/04\/4.Result-Function.png\n\" alt=\"4.Result-Function.png\"><\/a><\/center><\/code><\/pre>\n\n\n\n<p>Hope this blog helps you to add a various date Function to <a href=\"https:\/\/www.greytrix.com\/acumatica-cloud-erp\/\" target=\"_blank\" rel=\"noreferrer noopener\">Acumatica.<\/a><\/p>\n\n\n","protected":false},"excerpt":{"rendered":"<p>Introduction:&nbsp; Acumatica supports various date functions. In this blog, we will learn how to use various date Functions of Acumatica that can be used while printing Reports and Displaying GI. In this example we shall demonstrate the date functions usage in Generic Inquiry. DateDiff function:- The DATEDIFF() function returns the difference between two dates. To\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":2482,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[146,15,3,130,14],"tags":[4,159,16],"class_list":["post-1262","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-acumatica","category-acumatica-customization","category-acumatica-erp","category-acumatica-product","category-acumatica-services","tag-acumatica","tag-acumatica-customization","tag-acumatica-erp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Explore Date Functions in Acumatica<\/title>\n<meta name=\"description\" content=\"Explore diverse date functions in Acumatica for efficient data management and analysis. Enhance your workflow today.\" \/>\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\/04\/06\/various-date-function-in-acumatica\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Explore Date Functions in Acumatica\" \/>\n<meta property=\"og:description\" content=\"Explore diverse date functions in Acumatica for efficient data management and analysis. Enhance your workflow today.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/\" \/>\n<meta property=\"og:site_name\" content=\"Acumatica \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-06T09:06:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-02T05:53:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/04\/4.Result-Function-2-e1721372921886.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"193\" \/>\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=\"2 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\/04\/06\/various-date-function-in-acumatica\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/\",\"name\":\"Explore Date Functions in Acumatica\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/04\/4.Result-Function-2-e1721372921886.png\",\"datePublished\":\"2023-04-06T09:06:24+00:00\",\"dateModified\":\"2024-12-02T05:53:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec\"},\"description\":\"Explore diverse date functions in Acumatica for efficient data management and analysis. Enhance your workflow today.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/04\/4.Result-Function-2-e1721372921886.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/04\/4.Result-Function-2-e1721372921886.png\",\"width\":400,\"height\":193,\"caption\":\"Date Function in Acumatica\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Various Date Function 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":"Explore Date Functions in Acumatica","description":"Explore diverse date functions in Acumatica for efficient data management and analysis. Enhance your workflow today.","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\/04\/06\/various-date-function-in-acumatica\/","og_locale":"en_US","og_type":"article","og_title":"Explore Date Functions in Acumatica","og_description":"Explore diverse date functions in Acumatica for efficient data management and analysis. Enhance your workflow today.","og_url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/","og_site_name":"Acumatica \u2013 Tips, Tricks and Components","article_published_time":"2023-04-06T09:06:24+00:00","article_modified_time":"2024-12-02T05:53:13+00:00","og_image":[{"width":400,"height":193,"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/04\/4.Result-Function-2-e1721372921886.png","type":"image\/png"}],"author":"greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greytrix","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/","name":"Explore Date Functions in Acumatica","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/04\/4.Result-Function-2-e1721372921886.png","datePublished":"2023-04-06T09:06:24+00:00","dateModified":"2024-12-02T05:53:13+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec"},"description":"Explore diverse date functions in Acumatica for efficient data management and analysis. Enhance your workflow today.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/04\/4.Result-Function-2-e1721372921886.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2023\/04\/4.Result-Function-2-e1721372921886.png","width":400,"height":193,"caption":"Date Function in Acumatica"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2023\/04\/06\/various-date-function-in-acumatica\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/acumatica\/"},{"@type":"ListItem","position":2,"name":"Various Date Function 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\/1262","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=1262"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/1262\/revisions"}],"predecessor-version":[{"id":3048,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/1262\/revisions\/3048"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/media\/2482"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/media?parent=1262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/categories?post=1262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/tags?post=1262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}