{"id":24006,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/expression-fields-1\/"},"modified":"2025-02-25T13:28:33","modified_gmt":"2025-02-25T21:28:33","slug":"expression-fields-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/","title":{"rendered":"Expression Fields"},"content":{"rendered":"<p>Expression fields are used to calculate, and display the results of the calculation, on a column report, a Detailed report or a Quicklist report. For example, you might use a numeric expression to calculate the sum of two or more fields within an issue.\u00a0 The Default value of the expression field may store an expression that will be evaluated as the default when the field is placed on a report. See the section in this guide for <a href=\"v25\/reporting-querying-1\/\">Reporting and Querying<\/a> for a discussion of valid expressions.<\/p>\n<p>Expression fields with a type of Duration are used as filters in queries, where they compute the value associated with a <strong>date <\/strong>or <strong>day <\/strong>field.\u00a0 For example, you might use an expression to filter all the issues with a <em>date created<\/em> of <em>last month<\/em>.<\/p>\n<p>This list shows the built-in expressions provided with ExtraView.\u00a0 Administrators may create their own expressions.\u00a0 It is recommended that you do not alter the value of the built-in <em>duration<\/em> expressions.\u00a0 You may add additional expressions of any type.<\/p>\n<table style=\"width: 473px;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"background-color: #d3d3d3;\"><strong>Data dictionary field name<\/strong><\/td>\n<td style=\"background-color: #d3d3d3;\"><strong>Title<\/strong><\/td>\n<td style=\"background-color: #d3d3d3;\"><strong>Type<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_LAST_FISCAL_QUARTER<\/td>\n<td>Last fiscal quarter<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_LAST_FISCAL_YEAR<\/td>\n<td>Last fiscal year<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_LAST_FQ_TO_DATE<\/td>\n<td>Last fiscal quarter to date<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_LAST_FY_TO_DATE<\/td>\n<td>Last fiscal year to date<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_LAST_MONTH<\/td>\n<td>Last month<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_LAST_MONTH_TO_DATE<\/td>\n<td>Last month to date<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_LAST_WEEK<\/td>\n<td>Last week<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_LAST_WEEK_TO_DATE<\/td>\n<td>Last week to date<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_LAST_12_MONTHS<\/td>\n<td>Last 12 months<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_NEXT_4_WEEKS<\/td>\n<td>Next 4 weeks<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_NEXT_FISCAL_QUARTER<\/td>\n<td>Next fiscal quarter<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_NEXT_FISCAL_YEAR<\/td>\n<td>Next fiscal year<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_NEXT_MONTH<\/td>\n<td>Next month<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_NEXT_WEEK<\/td>\n<td>Next week<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_THIS_FISCAL_QUARTER<\/td>\n<td>This fiscal quarter<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_THIS_FISCAL_YEAR<\/td>\n<td>This fiscal year<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_THIS_FQ_TO_DATE<\/td>\n<td>This fiscal quarter to date<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_THIS_FY_TO_DATE<\/td>\n<td>This fiscal year to date<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_THIS_MONTH<\/td>\n<td>This month<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_THIS_MONTH_TO_DATE<\/td>\n<td>This month to date<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_THIS_WEEK<\/td>\n<td>This week<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_THIS_WEEK_TO_DATE<\/td>\n<td>This week to date<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_TODAY<\/td>\n<td>Today<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EVDTF_YESTERDAY<\/td>\n<td>Yesterday<\/td>\n<td>DURATION<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EXP_CURRENCY<\/td>\n<td>Expression &#8211; Currency<\/td>\n<td>CURRENCY<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EXP_DATE<\/td>\n<td>Expression &#8211; Date<\/td>\n<td>DATE<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EXP_DAY<\/td>\n<td>Expression &#8211; Day<\/td>\n<td>DAY<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EXP_DECIMAL<\/td>\n<td>Expression &#8211; Decimal<\/td>\n<td>DECIMAL<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EXP_NUMBER<\/td>\n<td>Expression &#8211; Number<\/td>\n<td>NUMBER<\/td>\n<\/tr>\n<tr>\n<td style=\"height: 20px;\">EXP_TEXTFIELD<\/td>\n<td>Expression &#8211; Text Field<\/td>\n<td>TEXTFIELD<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Expression fields are used to calculate, and display the results of the calculation, on a column report, a Detailed report or a Quicklist report. For example, you might use a numeric expression to calculate the sum of two or more fields within an issue.\u00a0 The Default value of the expression field may store an expression&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24000,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_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-24006","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Expression Fields - 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\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Expression Fields - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Expression fields are used to calculate, and display the results of the calculation, on a column report, a Detailed report or a Quicklist report. For example, you might use a numeric expression to calculate the sum of two or more fields within an issue.\u00a0 The Default value of the expression field may store an expression...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-25T21:28:33+00:00\" \/>\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\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/\",\"name\":\"Expression Fields - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-25T21:28:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Administration Guide\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Site Configuration Menu\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Data Dictionary\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Special Purpose Fields\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/\"},{\"@type\":\"ListItem\",\"position\":7,\"name\":\"Expression Fields\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/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\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Expression Fields - 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\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/","og_locale":"en_US","og_type":"article","og_title":"Expression Fields - Product Documentation","og_description":"Expression fields are used to calculate, and display the results of the calculation, on a column report, a Detailed report or a Quicklist report. For example, you might use a numeric expression to calculate the sum of two or more fields within an issue.\u00a0 The Default value of the expression field may store an expression...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-25T21:28:33+00:00","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\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/","name":"Expression Fields - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-25T21:28:33+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/expression-fields-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"Administration Guide","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/"},{"@type":"ListItem","position":4,"name":"Site Configuration Menu","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/"},{"@type":"ListItem","position":5,"name":"Data Dictionary","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/"},{"@type":"ListItem","position":6,"name":"Special Purpose Fields","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/data-dictionary-4\/special-purpose-fields-1\/"},{"@type":"ListItem","position":7,"name":"Expression Fields"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/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\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24006","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=24006"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24006\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24000"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}