--- title: Formatting dates in datasets description: Datafeed columns containing DateTime objects can formatted in many different ways within a dataset via the intuitive date functions provided as standard. For example, you may wish to display the Month --- [Skip to content](https://help.intuitivebusinessintelligence.com/formatting-dates#main-content) English Show submenu for translations ![Intuitive logo RGB-1.png\]](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20RGB-1.png?height=40&name=Intuitive%20logo%20RGB-1.png) Open main navigation Close main navigation - English Show submenu for translations - [Go to weareintuitive.com](https://weareintuitive.com/) [Go to weareintuitive.com](https://weareintuitive.com/) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Help Center](https://help.intuitivebusinessintelligence.com/?hsLang=en) 2. [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en) 3. [Datasets](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datasets) # Formatting dates in datasets Datafeed columns containing DateTime objects can formatted in many different ways within a dataset via the intuitive date functions provided as standard. For example, you may wish to display the Month that a date falls in or the Day of the week.   **#Design Tip 1**: It is sometime very useful to have a Date/Time stamp as a column in a datafeed to record the Date/Time the query was last run eg. *SELECT GETDATE() AS DateTimeStamp FROM Tablename* **#Design Tip 2:** Having a Date/Time stamp column present in a datafeed allows *Elapsed Time* calculations to be performed within in the dataset using the inbuilt [*date difference function*](https://help.intuitivebusinessintelligence.com/formatting-dates#Date-Difference-Function).   **To format at date column in a dataset:** 1. Open an existing (or create) dataset **Main Menu -> Dataset Designer -> Edit dataset** **![DatasetMenuEdit](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetMenuEdit.jpg?width=432&name=DatasetMenuEdit.jpg)** 2. Drag-and-drop the date column from the datafeed to the dataset.  3. Open the dataset Column Property Dialogue box by clicking on the dataset column header. A true date attribute will have the DateTime Type. Alter the Column Name here: ![DatasetColumnPropertyType](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetColumnPropertyType.jpg?width=519&name=DatasetColumnPropertyType.jpg) **Note**: If the column shows the **Type** as *String*, the column has not been imported to the datafeed as a true DateTime type and the datafeed may need to be amended.  4. Specify how you would like to format the date in the Format section: ![DatasetColumnPropertyFormat](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetColumnPropertyFormat.jpg?width=520&name=DatasetColumnPropertyFormat.jpg) 5. Choose the **Display type** to suit using the drop-down: ![DatasetColumnPropertyMonthDropdown-2](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetColumnPropertyMonthDropdown-2.jpg?width=280&name=DatasetColumnPropertyMonthDropdown-2.jpg) Example: In this case we want to derive the **Month** from the DateTime Column 6. Choose the **function** you would like applied to display the Month: ![DatasetColumnPropertyFunctionDropdown](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetColumnPropertyFunctionDropdown.jpg?width=268&name=DatasetColumnPropertyFunctionDropdown.jpg) In this case just the **Month Name** to be displayed 7. Choose the Start Month for month numbers i.e. If the start Month is set to April, April will be month 1 and March will be month 12. This allows for different financial year start dates. 8. Choose the **format** you would like to display the Month i.e. Short/Long Jan/January There are many different combinations of date formats that can be applied so listing every date function combination here not practical. The main display types are as follows and each has multiple functions and formats which can be applied: - Simple date - Example 09/04/2020 - Time - Example 12:00 AM (Note that time must be present in DateTime column) - Year - Example 2020 - Month - Example Month Number + Month Name Jan, January, 1, 12, 12-Jan - Period - Example 20-12 - Week - 20-01 - Quarter - Reporting quarter  - Day - Day of week - Date Difference - **See below** **Date Difference Function:** **![DatasetDateDiffFunction](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetDateDiffFunction.jpg?width=468&name=DatasetDateDiffFunction.jpg)** The **Display Type: Function: date Difference** gives the ability to compare two different date columns and display the difference between them i.e. 10 Days **or** 12 Months **or** 2 Years **or** 5 Minutes; a little like the standard DateDiff function in SQL: **Example**: You may wish to calculate the difference in **Days** between the **Document Date** and the **Due Date** of an invoice:  ![DatasetDateDiff-1](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetDateDiff-1.jpg?width=430&name=DatasetDateDiff-1.jpg) **Note**: Current Column Position defines which way round the two dates are compared.   **Comparing a date column to an absolute date** You may have a requirement to compare a DateTime column in the dataset with an absolute fixed date and time. i.e. How many days have elapsed since 01/01/1900 In this case, where you would normally select another DateTime column, there is a switch to allow you to enter an absolute date: ![DatasetDateDiff_02](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/DatasetDateDiff_02.jpg?width=688&name=DatasetDateDiff_02.jpg)       - [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#main-content) - [Getting Started](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#getting-started) - [Viewing Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#viewing-dashboards) - [Interacting with dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#interacting-with-dashboards) - [Filters](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#filters) - [Connections](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#connections) - [Datafeeds](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datafeeds) - [Datasets](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datasets) - [Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#components) - [Creating Dashboards and Components - Overview](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-dashboards-and-components-overview) - [Creating Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-components) - [Creating a Dashboard](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-a-dashboard) - [Administering the System](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-the-system) - [Administering Users](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-users) - [Administering Groups](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-groups) - [Security Filters - V5.2 and earlier](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-2-and-earlier) - [Security Filters - V5.3 Onward](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-3-onward) - [Embedding Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#embedding-dashboards) - [Configuration File](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#configuration-file) - [Installation & Configuration Guide](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#installation-configuration-guide) - [Version History](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#version-history) - [Intuitive for PaperCut V2](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#main-content) - [Installing Intuitive for PaperCut](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#installing-intuitive-for-papercut) - [Viewing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#viewing-papercut-dashboards) - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#editing-papercut-dashboards) - [Intuitive for PaperCut Demonstration Videos](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-demonstration-videos) - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-faqs) - [Intuitive for PaperCut MF V3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#main-content) - [Installing Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#installing-intuitive-for-papercut-version-3) - [Viewing the dashboards - Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-version-3) - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#editing-papercut-dashboards) - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#intuitive-for-papercut-faqs) - [Intuitive for SAFEQ](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#main-content) - [General Help](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#general-help) - [Software Installation](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#software-installation) - [Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#solution-expertise) - [Intuitive For Managed Print Services (MPS)](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#main-content) - [Intuitive for MPS - Overview](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-overview) - [Intuitive for MPS - Installation Steps](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-installation-steps) - [Intuitive for MPS - Import File Layouts](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-import-file-layouts) - [Intuitive For MPS - Loading the Data Warehouse](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-loading-the-data-warehouse) - [Intuitive Cloud Services](https://help.intuitivebusinessintelligence.com/intuitive-cloud-services?hsLang=en) - [Intuitive for PaperCut Hive V1](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#main-content) - [Viewing the dashboards - Intuitive for PaperCut Hive](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-hive) - [Intuitive for SAFEQ Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#main-content) - [Intuitive Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-solution-expertise) - [Intuitive Software Provisioning](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-software-provisioning) - [Intuitive for Docuware](https://help.intuitivebusinessintelligence.com/intuitive-for-docuware?hsLang=en) - [Intuitive for Print Management](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#main-content) - [Solution Knowledge](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#solution-knowledge) - [Technical Information](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#technical-information) - [Intuitive for e-BRIDGE Global Print](https://help.intuitivebusinessintelligence.com/intuitive-for-e-bridge-global-print?hsLang=en) - [Intuitive for e-FOLLOW Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-e-follow-cloud?hsLang=en) - [FAQ](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#main-content) - [Connections](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#connections) - [General Enquiries](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#general-enquiries) - [Datafeeds](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datafeeds) - [Datasets](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datasets) - [System Compatability](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#system-compatability) - [Software Installation](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#software-installation) [![Chill listening crop-3](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20BLACK.png?width=102&height=24&name=Intuitive%20logo%20BLACK.png "Chill listening crop-3")](https://help.intuitivebusinessintelligence.com?hsLang=en) weareintuitive.com Help Center Copyright © 2026, Intuitive Business Intelligence Limited