# \#date-time-fields **URL:** https://forums.knack.com/tag/date-time-fields/142.md [Latest](https://forums.knack.com/latest.md) · [Categories](https://forums.knack.com/categories.md) · [Tags](https://forums.knack.com/tags.md) --- ## [Calculating days between two dates](https://forums.knack.com/t/calculating-days-between-two-dates/8906)
**Author:** [@AndrewBang54366](https://forums.knack.com/u/AndrewBang54366)\ **Replies:** 4\ **Last updated:** [May 4, 2023, 4:38pm UTC](https://forums.knack.com/t/calculating-days-between-two-dates/8906 "2023-05-04T16:38:18Z")
I think Knack could use one more date function to calculate the number of days between two dates. Subtracting two dates doesn't quite work because the system uses both date and time for each field even if "ignore time" i… --- ## [Max/Min Dates in Formulas](https://forums.knack.com/t/max-min-dates-in-formulas/9513)
**Author:** [@JeremyNels15348](https://forums.knack.com/u/JeremyNels15348)\ **Replies:** 23\ **Last updated:** [March 2, 2023, 5:01pm UTC](https://forums.knack.com/t/max-min-dates-in-formulas/9513 "2023-03-02T17:01:07Z")
We need to be able to calculate the earliest/latest date from a set of connected records (e.g. first client visit or last client visit). Max/Min don't currently work for date fields. --- ## [Add date filters for ROLLING dates: days, weeks, months](https://forums.knack.com/t/add-date-filters-for-rolling-dates-days-weeks-months/9460)
**Author:** [@EricAlderman](https://forums.knack.com/u/EricAlderman)\ **Replies:** 9\ **Last updated:** [August 4, 2022, 8:17pm UTC](https://forums.knack.com/t/add-date-filters-for-rolling-dates-days-weeks-months/9460 "2022-08-04T20:17:51Z")
Allow filters for "today AND the previous/next X \[days,weeks,months,years\]" Date filters currently include "during the previous" period for days, weeks, and months. These will specify records that have dates for the "pr… --- ## [New Date Validation Options](https://forums.knack.com/t/new-date-validation-options/11656)
**Author:** [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\ **Replies:** 4\ **Last updated:** [December 8, 2021, 6:04pm UTC](https://forums.knack.com/t/new-date-validation-options/11656 "2021-12-08T18:04:07Z")
I noticed today that there are some additional validation rules available on dates. I may be behind the curve on this update :blush: This will make things a bit easier to ensure even better data validation. is a day … --- ## [Showing quarters in date/time](https://forums.knack.com/t/showing-quarters-in-date-time/11375)
**Author:** [@Lisa](https://forums.knack.com/u/Lisa)\ **Replies:** 1\ **Last updated:** [October 18, 2021, 9:43am UTC](https://forums.knack.com/t/showing-quarters-in-date-time/11375 "2021-10-18T09:43:22Z")
Dear all, our firm develops PBSA and hotels around Europe, where the projects undergo different phases. In the initial phases the construction end/planned opening of a project is not 100% set on the day. We can only ind… --- ## [Ability to set the value of a Date field with Start/End dates using a Conditional Rule](https://forums.knack.com/t/ability-to-set-the-value-of-a-date-field-with-start-end-dates-using-a-conditional-rule/9421)
**Author:** [@EricAlderman](https://forums.knack.com/u/EricAlderman)\ **Replies:** 0\ **Last updated:** [June 5, 2017, 9:12pm UTC](https://forums.knack.com/t/ability-to-set-the-value-of-a-date-field-with-start-end-dates-using-a-conditional-rule/9421 "2017-06-05T21:12:00Z")
You should be able to set a Date field (that is set to use Start and End dates) to a value that includes both dates, like "03/06/2017 00:30 to 03/07/2017 01:30" using a Conditional Rule. This is exactly the format speci… --- ## [Enable Time restriction in Time/Date field](https://forums.knack.com/t/enable-time-restriction-in-time-date-field/6306)
**Author:** [@QuestonChu24290](https://forums.knack.com/u/QuestonChu24290)\ **Replies:** 0\ **Last updated:** [August 14, 2018, 9:48am UTC](https://forums.knack.com/t/enable-time-restriction-in-time-date-field/6306 "2018-08-14T09:48:00Z")
As a Builder, I would like to be able to setup up start and end times for the date picker to display. Currently our timeslots are only available from 9am - 9pm, but the picker still shows available times from 9pm-9am whi… --- ## [Allow Customisation of Timer field input](https://forums.knack.com/t/allow-customisation-of-timer-field-input/6369)
**Author:** [@LoriPolkin95153](https://forums.knack.com/u/LoriPolkin95153)\ **Replies:** 0\ **Last updated:** [November 3, 2018, 10:51pm UTC](https://forums.knack.com/t/allow-customisation-of-timer-field-input/6369 "2018-11-03T22:51:00Z")
There is no ability to customise input of the Timer field. Currently it defaults to current time as start time and adds 1 hour for end time. Would like to be able to set it NOT to default like this. Also, it would be use… --- ## [Date field input data values](https://forums.knack.com/t/date-field-input-data-values/8900)
**Author:** [@RayWindlow56888](https://forums.knack.com/u/RayWindlow56888)\ **Replies:** 0\ **Last updated:** [August 2, 2020, 8:29pm UTC](https://forums.knack.com/t/date-field-input-data-values/8900 "2020-08-02T20:29:00Z")
Often have data provided digitally in variety of formats i.e 23 Jun 1995 Jun 23 1995 Because of date format being limited to a single nominated format mean we can't cut and past data into the field. Would like to se… --- ## [Fixed date format for API](https://forums.knack.com/t/fixed-date-format-for-api/10581)
**Author:** [@MichalCese42453](https://forums.knack.com/u/MichalCese42453)\ **Replies:** 1\ **Last updated:** [February 13, 2020, 5:18pm UTC](https://forums.knack.com/t/fixed-date-format-for-api/10581 "2020-02-13T17:18:17Z")
While Knack enables us to change display date format we cannot send data via REST API in one fixed format. The POST and PUT methods should be deliberated from the UI data format and use only one format for all the date f… --- ## [Date fields filters - from a specific date to a specific date](https://forums.knack.com/t/date-fields-filters-from-a-specific-date-to-a-specific-date/9278)
**Author:** [@Guilhermeb42087](https://forums.knack.com/u/Guilhermeb42087)\ **Replies:** 1\ **Last updated:** [April 4, 2019, 5:24pm UTC](https://forums.knack.com/t/date-fields-filters-from-a-specific-date-to-a-specific-date/9278 "2019-04-04T17:24:51Z")
I would like to have an option on date field filters (table and search) that let me add a starting date and an end date to the filter... --- ## [Week Filter to start on MONDAY](https://forums.knack.com/t/week-filter-to-start-on-monday/9841)
**Author:** [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)\ **Replies:** 1\ **Last updated:** [September 25, 2018, 9:25pm UTC](https://forums.knack.com/t/week-filter-to-start-on-monday/9841 "2018-09-25T21:25:41Z")
As a Builder I would like all filters that use "week" (is during the current week, is during the past week) to start on Monday instead of Sunday. Use Case: Our business calendars work on a sales cycle that is Monday-Sun… --- ## [Timezone included on date/time fields](https://forums.knack.com/t/timezone-included-on-date-time-fields/6296)
**Author:** [@JamesAuger11978](https://forums.knack.com/u/JamesAuger11978)\ **Replies:** 4\ **Last updated:** [July 8, 2018, 9:04pm UTC](https://forums.knack.com/t/timezone-included-on-date-time-fields/6296 "2018-07-08T21:04:10Z")
As a Builder, I would like a timezone to be included with a date / time field so that I can clearly see our identified pickup & delivery times. For example, Pickup date is 7/20/2018 at 14:00 ET, Delivery date is 7/24/201… --- ## [Extracting "From" and "To" Values in single Date/Time field](https://forums.knack.com/t/extracting-from-and-to-values-in-single-date-time-field/8987)
**Author:** [@StephenChapman](https://forums.knack.com/u/StephenChapman)\ **Replies:** 7\ **Last updated:** [December 16, 2017, 4:05am UTC](https://forums.knack.com/t/extracting-from-and-to-values-in-single-date-time-field/8987 "2017-12-16T04:05:48Z")
As a Knack Builder, I would like to be able to extract single parts from a Date/Time fields so that I can use (and display) those individual components on particular views. Scenario: Currently this takes many extraction… --- ## [Feature: "Most recent" option in calculated field](https://forums.knack.com/t/feature-most-recent-option-in-calculated-field/5703)
**Author:** [@SimonChapl76845](https://forums.knack.com/u/SimonChapl76845)\ **Replies:** 3\ **Last updated:** [October 19, 2015, 2:50pm UTC](https://forums.knack.com/t/feature-most-recent-option-in-calculated-field/5703 "2015-10-19T14:50:02Z")
It would be great to have a "most recent" option in the calculated field, as a different option from min, max and average. It would be particularly useful for date driven records.