{"id":22267,"date":"2024-02-15T14:48:40","date_gmt":"2024-02-15T22:48:40","guid":{"rendered":"https:\/\/docs.extraview.com\/v22\/book\/rules-date-calculations\/"},"modified":"2024-02-15T14:48:40","modified_gmt":"2024-02-15T22:48:40","slug":"rules-date-calculations","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/","title":{"rendered":"Rules & Date Calculations"},"content":{"rendered":"

Date calculations where you want to compute the difference between two dates, giving a numeric result are an exception to the above syntax. This is because you desire a numeric result and you cannot assign a date to a number without causing an error. The correct syntax to calculate the difference between two dates (DAT_1<\/span> and DAT_2<\/span>) and place the result in the field DIFF<\/span> is:<\/p>\n

DIFF = (DAT1 – DAT2);<\/span><\/p>\n

Date differences in rules may specify qualifiers to get results computed in units other than days. The qualifiers are {seconds}<\/span>, {minutes}<\/span>, {hours}<\/span>, and {days}<\/span>. Each of these results in an integral value after the date difference is computed. The fractional part of the computation is truncated, not rounded. This implies that the meaning is “the integral number of between the two dates”.<\/p>\n

Example:<\/p>\n

\n\t## compute number of seconds between two dates<\/div>\n
\n\tX_NUMBER = (X_DATE1 – X_DATE2).{seconds};<\/div>\n
\n\t## compute integral number of days between two dates<\/div>\n
\n\tX_DECIMAL = (X_DATE1 – X_DATE2).{days};<\/div>\n
\n\t## compute total (including fractional) days between two dates<\/div>\n
\n\tX_DECIMAL_DAYS = (X_DATE1 – X_DATE2);<\/div>\n

You can specify a specific business calendar to use with date calculations. This is done with the calendar<\/span> directive. For example, if you use the WEEKDAY calendar provided with ExtraView, and you have a calculation such as:<\/p>\n

\n\t <\/div>\n
\n\t<== calendar WEEKDAY ==><\/div>\n
\n\tDATE_RESULT  = SYSDATE;<\/div>\n
\n\tDATE_RESULT += 3;<\/div>\n

where SYSDATE<\/span> is a Thursday, the result will be Tuesday, i.e. it is 3 workdays, plus the 2 weekend days.<\/p>\n

If you add 0 to a date using a business calendar, the result will skip to the first work day beyond that date if that date is not a work day.<\/p>\n

Null date and day field values have special treatment. When a date or day field has a null value, and is being used in a calculation, it is assumed the null date is January 1st, 1900<\/em>. This avoids errors and null results occuring. However, tests on date and day type fields with value qualifiers such as date_field.{is null}<\/span> and date_field.{not null}<\/span> return true or false depending on whether there is a null value.<\/p>\n

\n\tDate fields and Day Fields<\/h3>\n

Using a Day type field within a Business Rule is consistent when it is compared or combined in expressions with other Day type fields. When compared with Date fields, the Date is converted to a Day value using the user’s time zone (to which the Date value is, by definition, relative) and the comparison is done with a Day field to Day field comparison or calculation.<\/p>\n","protected":false},"excerpt":{"rendered":"

Date calculations where you want to compute the difference between two dates, giving a numeric result are an exception to the above syntax. This is because you desire a numeric result and you cannot assign a date to a number without causing an error. The correct syntax to calculate the difference between two dates (DAT_1…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-22267","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nRules & Date Calculations - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Rules & Date Calculations - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Date calculations where you want to compute the difference between two dates, giving a numeric result are an exception to the above syntax. This is because you desire a numeric result and you cannot assign a date to a number without causing an error. The correct syntax to calculate the difference between two dates (DAT_1...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/\",\"url\":\"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/\",\"name\":\"Rules & Date Calculations - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/#website\"},\"datePublished\":\"2024-02-15T22:48:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v22\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rules & Date Calculations\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v22\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v22\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v22\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Rules & Date Calculations - Product Documentation","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:\/\/docs.extraview.com\/v22\/rules-date-calculations\/","og_locale":"en_US","og_type":"article","og_title":"Rules & Date Calculations - Product Documentation","og_description":"Date calculations where you want to compute the difference between two dates, giving a numeric result are an exception to the above syntax. This is because you desire a numeric result and you cannot assign a date to a number without causing an error. The correct syntax to calculate the difference between two dates (DAT_1...","og_url":"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/","og_site_name":"Product Documentation","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/","url":"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/","name":"Rules & Date Calculations - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v22\/#website"},"datePublished":"2024-02-15T22:48:40+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v22\/rules-date-calculations\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v22\/"},{"@type":"ListItem","position":2,"name":"Rules & Date Calculations"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v22\/#website","url":"https:\/\/docs.extraview.com\/v22\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v22\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v22\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v22\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v22\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v22\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/pages\/22267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/comments?post=22267"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/pages\/22267\/revisions"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/media?parent=22267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}