--- title: Date Calculated Fields description: Date formulas can be used to output different date and time information. --- [Skip to content](https://gohub.casebook.net/knowledge/date-calculated-fields#main-content) [More support](https://gohub.casebook.net/knowledge/kb-tickets/new) [![logo-raspberry (1)](https://gohub.casebook.net/hs-fs/hubfs/logo-raspberry%20(1).png?width=1286&height=255&name=logo-raspberry%20(1).png)](https://gohub.casebook.net/) - [Knowledge Base](https://gohub.casebook.net/knowledge) - [Video Library](https://gohub.casebook.net/video-library) - [Still Need Help?](https://gohub.casebook.net/knowledge/kb-tickets/new) Open main navigation Close main navigation - [Knowledge Base](https://gohub.casebook.net/knowledge) - [Video Library](https://gohub.casebook.net/video-library) - [Still Need Help?](https://gohub.casebook.net/knowledge/kb-tickets/new) - [More support](https://gohub.casebook.net/knowledge/kb-tickets/new) Hi. How can we help? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://gohub.casebook.net/knowledge) 2. [Reporting](https://gohub.casebook.net/knowledge/reporting) 3. [Calculated Fields](https://gohub.casebook.net/knowledge/reporting#calculated-fields) # Date Calculated Fields ## Date formulas can be used to output different date and time information. ### The functions included in the date category are: | Function Name | Syntax and Sample | | --- | --- | | **date**: date will return a date set to the values you include in your formula. | Syntax: date({year},{month},{day},{hour},{minute},{second}) | | Sample: date(1971,11,08,12,59,08) | | | **day**: day uses the date syntax, and returns the third value in the formula. | Syntax: day({date}) | | Sample: day(date(1971,11,08,01,22,44)) | | | **hour**: hour uses the date syntax, and returns the fourth value in the formula. | Syntax: hour({date}) | | Sample: hour(date(2017,12,1,12,33,48)) | | | **minute**: minute uses the date syntax, and returns the fifth value in the formula. | Syntax: minute({date}) | | Sample: minute(date(2017,12,1,12,33,48)) | | | **month**: month uses the date syntax, and returns the second value in the formula. | Syntax: month({date}) | | Sample: month(date(2017,12,1,12,33,48)) | | | **monthname**: monthname uses the date syntax, and returns the month name for a date. | Syntax: monthname({date},{locale}) | | Sample: monthname(date(2017,12,1,12,33,48),"en") | | | **now**: now returns the current date and time. | Syntax: now() | | Sample: now() | | | **quarter**: quarter uses the date syntax, and returns the quarter to which your date belongs. | Syntax: quarter({date}) | | Sample: quarter(date(2017,12,1,12,33,48)) | | | **second**: second uses the date syntax, and returns the sixth value in the formula. | Syntax: second({date}) | | Sample: second(date(2017,12,1,12,33,48)) | | | **time**: When you use time, Reveal will return a time set to the values you include in your formula. | Syntax: time({hour},{minute},{second},{millisecond}) | | Sample: time(11,08,08,11) | | | **today**: today returns the current date. | Syntax: today() | | Sample: today() | | | **weekday**: weekday uses the date syntax, and returns the day of the week your date falls into. | Syntax: weekday({date}) | | Sample: weekday(date(2017,12,1,12,33,48)) | | | **weeknum**: weeknum uses the date syntax, and returns the number of the week your date falls into within the specified year. | Syntax: weeknum({date}) | | Sample: weeknum(date(2017,12,1,12,33,48)) | | | **year**: year uses the date syntax, and returns the first value in the formula. | Syntax: year({date}) | | Sample: year(date(2017,12,1,12,33,48)) | | | **datediff:** find the difference between two dates. | DateDiff(\[start\_datetime\], \[end\_datetime\], "d") You will need to adjust the function to include the date fields you are looking to use. You can also adjust the third parameter, which corresponds to: "d" difference in days "h" difference in hours "dh" difference in remaining hours | - [Getting Started With Casebook](https://gohub.casebook.net/knowledge/getting-started-with-casebook#main-content) - [Casebook Overview](https://gohub.casebook.net/knowledge/getting-started-with-casebook#casebook-overview) - [Getting Started for New Users](https://gohub.casebook.net/knowledge/getting-started-with-casebook#getting-started-for-new-users) - [Services in Casebook](https://gohub.casebook.net/knowledge/getting-started-with-casebook#services-in-casebook) - [Notes](https://gohub.casebook.net/knowledge/getting-started-with-casebook#notes) - [Admin](https://gohub.casebook.net/knowledge/admin#main-content) - [Casebook Security](https://gohub.casebook.net/knowledge/admin#casebook-security) - [Roles and Permissions](https://gohub.casebook.net/knowledge/admin#roles-and-permissions) - [User Management](https://gohub.casebook.net/knowledge/admin#user-management) - [Notifications](https://gohub.casebook.net/knowledge/admin#notifications) - [Data](https://gohub.casebook.net/knowledge/admin#data) - [Field Configuration](https://gohub.casebook.net/knowledge/admin#field-configuration) - [Dynamic Fields](https://gohub.casebook.net/knowledge/admin#dynamic-fields) - [Forms](https://gohub.casebook.net/knowledge/admin#forms) - [Implementation & Adoption](https://gohub.casebook.net/knowledge/admin#implementation-adoption) - [People](https://gohub.casebook.net/knowledge/people) - [Intake](https://gohub.casebook.net/knowledge/intake) - [Engage](https://gohub.casebook.net/knowledge/engage#main-content) - [Text Messages](https://gohub.casebook.net/knowledge/engage#text-messages) - [Configuration](https://gohub.casebook.net/knowledge/engage#configuration) - [Notes](https://gohub.casebook.net/knowledge/engage#notes) - [Track](https://gohub.casebook.net/knowledge/track) - [Access](https://gohub.casebook.net/knowledge/access) - [Workflow & Tasks](https://gohub.casebook.net/knowledge/workflow-tasks) - [Reporting](https://gohub.casebook.net/knowledge/reporting#main-content) - [Overview](https://gohub.casebook.net/knowledge/reporting#overview) - [Datasets](https://gohub.casebook.net/knowledge/reporting#datasets) - [Dashboards](https://gohub.casebook.net/knowledge/reporting#dashboards) - [Pre-built Reports](https://gohub.casebook.net/knowledge/reporting#pre-built-reports) - [Custom Reports](https://gohub.casebook.net/knowledge/reporting#custom-reports) - [Data Visualizations](https://gohub.casebook.net/knowledge/reporting#data-visualizations) - [Filters](https://gohub.casebook.net/knowledge/reporting#filters) - [Calculated Fields](https://gohub.casebook.net/knowledge/reporting#calculated-fields) - [Other](https://gohub.casebook.net/knowledge/reporting#other) - [Audit Logs](https://gohub.casebook.net/knowledge/audit-logs) - [Integrations](https://gohub.casebook.net/knowledge/integrations#main-content) - [Low-code incoming integrations with Zapier](https://gohub.casebook.net/knowledge/integrations#low-code-incoming-integrations-with-zapier) - [Custom incoming integrations with Casebook API](https://gohub.casebook.net/knowledge/integrations#custom-incoming-integrations-with-casebook-api) - [Custom outgoing integrations with Webhooks](https://gohub.casebook.net/knowledge/integrations#custom-outgoing-integrations-with-webhooks) - [Program Area Specific](https://gohub.casebook.net/knowledge/program-area-specific#main-content) - [VOCA Reporting](https://gohub.casebook.net/knowledge/program-area-specific#voca-reporting) - [Customer Support](https://gohub.casebook.net/knowledge/customer-support#main-content) - [Getting Unstuck](https://gohub.casebook.net/knowledge/customer-support#getting-unstuck) - [Account Management](https://gohub.casebook.net/knowledge/customer-support#account-management) - [Product Release Notes](https://gohub.casebook.net/knowledge/product-release-notes#main-content) - [2026](https://gohub.casebook.net/knowledge/product-release-notes#2026) - [2025](https://gohub.casebook.net/knowledge/product-release-notes#2025) - [2024](https://gohub.casebook.net/knowledge/product-release-notes#2024) - [2023](https://gohub.casebook.net/knowledge/product-release-notes#2023) - [2022](https://gohub.casebook.net/knowledge/product-release-notes#2022) - [2021](https://gohub.casebook.net/knowledge/product-release-notes#2021) - [2020](https://gohub.casebook.net/knowledge/product-release-notes#2020) - [Frequently Asked Questions](https://gohub.casebook.net/knowledge/frequently-asked-questions#main-content) - [Global](https://gohub.casebook.net/knowledge/frequently-asked-questions#global) - [Casebook Calendar](https://gohub.casebook.net/knowledge/frequently-asked-questions#casebook-calendar) - [Casebook Services](https://gohub.casebook.net/knowledge/frequently-asked-questions#casebook-services) - [Casebook Forms](https://gohub.casebook.net/knowledge/frequently-asked-questions#casebook-forms) - [Casebook Notes](https://gohub.casebook.net/knowledge/frequently-asked-questions#casebook-notes) - [cb Admin](https://gohub.casebook.net/knowledge/frequently-asked-questions#cb-admin) - [cb Track](https://gohub.casebook.net/knowledge/frequently-asked-questions#cb-track) - [cb Reporting](https://gohub.casebook.net/knowledge/frequently-asked-questions#cb-reporting) - [cb Access](https://gohub.casebook.net/knowledge/frequently-asked-questions#cb-access) - [Program Specific](https://gohub.casebook.net/knowledge/frequently-asked-questions#program-specific) [![logo-raspberry-1-1](https://gohub.casebook.net/hs-fs/hubfs/logo-raspberry-1-1.png?width=32&height=30&name=logo-raspberry-1-1.png "logo-raspberry-1-1")](https://www.casebook.net/) © 2025 Casebook. All rights reserved. Casebook Knowledge Base [Video Library](https://gohub.casebook.net/video-library) [Still Need Help?](https://gohub.casebook.net/knowledge/kb-tickets/new)