{"id":205,"date":"2022-06-09T19:38:11","date_gmt":"2022-06-09T19:38:11","guid":{"rendered":"https:\/\/docs.xlreport.com\/docs\/admin-user\/date-expressions\/"},"modified":"2022-06-09T19:38:50","modified_gmt":"2022-06-09T19:38:50","slug":"date-expressions","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/expression-and-formulas\/date-expressions\/","title":{"rendered":"Date Expressions"},"content":{"rendered":"<p>If you need to convert a date value into a Year, Month, Week or Quarter value, XLReport will automatically insert the required expression for you.<\/p>\n<p class=\"note\">Note! This functionality only applies for Data Connections to MS SQL Server, MS Access, MySQL and Oracle databases.<\/p>\n<h3>Add a new expression<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/38.png\" \/><\/p>\n<ul>\n<li value=\"1\">Select the table \/ view and field which holds the date value and <span class=\"DoIt\">click the Expression &#8211; Date Function<\/span> button.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/39.png\" \/><\/p>\n<ul>\n<li value=\"1\">Select a <span class=\"DoIt\">Date Function<\/span> and <span class=\"DoIt\">click Ok<\/span> .<\/li>\n<\/ul>\n","protected":false},"featured_media":0,"parent":203,"menu_order":5,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/205"}],"collection":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/comments?post=205"}],"version-history":[{"count":1,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/205\/revisions"}],"predecessor-version":[{"id":206,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/205\/revisions\/206"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/203"}],"next":[{"title":"Convert Field Type Expression","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/expression-and-formulas\/convert-field-type-expression\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/207"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=205"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}