# Released: Improvements to Workflows that use Date/Time fields **URL:** \ **Category:** Announcements\ **Tags:** usability\ **Created:** [November 21, 2022, 5:10pm UTC](https://forums.knack.com/t/released-improvements-to-workflows-that-use-date-time-fields/13431 "2022-11-21T17:10:07Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Kara](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/kara/32/2717_2.png) [@Kara](https://forums.knack.com/u/Kara)\ **Post date:** [November 21, 2022, 5:10pm UTC](https://forums.knack.com/t/released-improvements-to-workflows-that-use-date-time-fields/13431/1 "2022-11-21T17:10:07Z")
**Released: Significant improvements to workflows that rely on the Date/Time field.** **What’s new** Users of the Builder and LiveApp will have more flexible filtering and rule options with consistent and accurate results. **Why** The changes being released next week will ensure parity between the Builder and Live App, correct unexpected behavior, and improve the overall user experience. **What’s new!** Filter for, and create rules for very granular - or broad - data with one click. **Checkboxes for “Any Date” and “Any Time” on Rules and Filters** ![Checkboxes_1](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/3/3d443631441ebfd3e460ba3d606ea41f86895f7b.png) **Rolling weeks and rolling months add more flexible date choices.** ![Rolling_2](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/3/3e622e6504d63e3393e91de69d2c0a19dd9ad6f3.png) ![](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/e/e0305ad9408cfa54fef8919002876ce25dd26d42.png) **Time Filters will be available in the Live App !** ![Time_3](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/7/740a8a2b884c01c1319ce85d9575e3950b808f5d.png) * * * **Changes to Rules** **Fix: Validation Rules will work as expected for Date and Time criteria** **Pre-release, validation rules for any combination of dates, times, and some operators did not run.** Example: - ![](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/3/3276e7cd2e48d9e41a117f35aaabe4992fb2e279.png) After the release, all combinations of date, time, and operators will run as expected. ![](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/3/33b3f05eb68b025a83d4ec2985457f1c1d75085b.png) [Why you should know:](https://docs.google.com/document/d/1P4Nt66n8EWd_4l-XK99lRCA4tBovt9mYTezkKG-6PlU/edit#heading=h.cs7ww2bdpkul) Validation Rules will now run as expected when using a Date/Time field for the criteria, including date and time, just date, or just time. Some customers may not realize field validation rules were not working, so now they’ll see saved workflows starting to run. Previously, conditional rules only worked with date or time fields; now, they work when both date and time are enabled on the field. These are the areas that may have saved workflows: - Conditional Rules - Validation Rules - Submit Rules - Page Rules - Display Rules - Record Rules - Email Rules Powerful workflows based on date and time rules will unlock automation processes, giving you time to focus on more important work. * * * **Changes to Filters** **Fix: Filters will work as expected for Date and Time criteria** **Pre-release, filters, with any operators, that included time, were not respecting the time field. For example, filtering for a specific date and time would show results for the entire day.** ![](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/1/1194411f8ae772e6ea335763380b498e1196df80.png) After the release, the same filter will run for records matching the exact time. **Why you should know:** In this scenario, the filter will return results based on specific times. If there are filters saved with specific times, and the current behavior of showing all results are preferred, then pre-release, the time field can be cleared out, or post-release, the new “any time” checkbox can be selected. These are the areas that may have saved filters: - Data Source Filters - Filter Menus - Custom Filter defaults - Connection Picker filters - Formula Field Filters - Tasks To keep the current behavior of showing all records regardless of time: ![](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/4/4a09198662cc764116a805e7a00f3adaafea540d.png) ![](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/5/55921171d1539420b6ce7f042e250cb9ac3d5019.png) * * * **Rolling Dates** \*\* Change: Changes to Weeks and Months\*\* **Pre-release: Currently, weeks and months are treated as rolling weeks and months, and not calendar weeks and months.** [Why you should know:](https://docs.google.com/document/d/1P4Nt66n8EWd_4l-XK99lRCA4tBovt9mYTezkKG-6PlU/edit#heading=h.cs7ww2bdpkul) This additional flexibility will change the behavior of saved rules and filters and may need updating post release. Weeks and months in the app now will be changed to calendar weeks and months. A calendar week is defined as Sunday through Saturday. A calendar month is defined as the first through the last day of the month. To retain the current behavior for weeks and months, after the release, update settings to the new rolling weeks and rolling months options. * * * #### Thank you All of us at Knack appreciate and thank our customers who have been patiently waiting for these updates and corrections to be released. With this release, you can be confident that automated workflows are running smoothly and expected record results are displayed. Please reach out to [support@knack.com](mailto:support@knack.com) if you have any questions about these updates. * * * #### FAQ’s ##### Will existing rules and filters be changed? Rules and filters that have been set up will not change, however, the results of a filter, or when a rule is triggered, may change. ##### What specifically is not working as expected pre-release? - Conditional Rules: will not work with date/time fields using date and time - Validation Rules: will not work with date/time fields using date and time, just date, or just time - Page Rules: will not work with date/time fields using date and time, just date, or just time - Submit Rules: will not work with date/time fields using date and time, just date, or just time - Display Rules (table, details, and form): will not work with date/time fields using date and time, just date, or just time - Record Rules (form and inline): will not work with date/time fields using date and time - Email: will not work with date/time fields using date and time, just date, or just time ##### What’s the difference between rolling and calendar weeks and months? The “rolling” means that the periods change daily, weekly, monthly, etc, depending on the circumstances. In other words, a rolling period “rolls” with whatever the current day is. Conversely, a week/month/year is considered a calendar period, with a week defined as Sunday-Saturday. ---
**Author:** ![KnackPros](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/knackpros/32/807_2.png) [@KnackPros](https://forums.knack.com/u/KnackPros)\ **Post date:** [November 21, 2022, 6:36pm UTC](https://forums.knack.com/t/released-improvements-to-workflows-that-use-date-time-fields/13431/2 "2022-11-21T18:36:39Z")
Looking forward to these changes 🎉 ---
**Author:** ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)\ **Post date:** [November 21, 2022, 10:41pm UTC](https://forums.knack.com/t/released-improvements-to-workflows-that-use-date-time-fields/13431/3 "2022-11-21T22:41:51Z")
Thank you. That’s a much appreciated improvement. ---
**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\ **Post date:** [November 21, 2022, 10:52pm UTC](https://forums.knack.com/t/released-improvements-to-workflows-that-use-date-time-fields/13431/4 "2022-11-21T22:52:22Z")
Great news, good to see things moving forward 🚀 ---
**Author:** ![MichaelG](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/michaelg/32/758_2.png) [@MichaelG](https://forums.knack.com/u/MichaelG)\ **Post date:** [November 22, 2022, 9:58am UTC](https://forums.knack.com/t/released-improvements-to-workflows-that-use-date-time-fields/13431/5 "2022-11-22T09:58:27Z")
Great! thank you. > [@Kara](#): > > Pre-release: Currently, weeks and months are treated as rolling weeks and months, and not calendar weeks and months. I thought the actual filter “previous” week/month/year was calendar date not rolling. I am surprised. ok ---
**Author:** ![Amaan](https://avatars.discourse-cdn.com/v4/letter/a/b3f665/32.png) [@Amaan](https://forums.knack.com/u/Amaan)\ **Post date:** [November 27, 2022, 8:45am UTC](https://forums.knack.com/t/released-improvements-to-workflows-that-use-date-time-fields/13431/6 "2022-11-27T08:45:15Z")
It would be great to have this available to run relative to another date field ---
**Author:** ![Wolfgang\_Brötz](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/wolfgang_br%C3%B6tz/32/1465_2.png) [@Wolfgang\_Brötz](https://forums.knack.com/u/Wolfgang_Br%C3%B6tz)\ **Post date:** [December 1, 2022, 1:24pm UTC](https://forums.knack.com/t/released-improvements-to-workflows-that-use-date-time-fields/13431/7 "2022-12-01T13:24:26Z")
+1 ---
**Author:** ![Sean](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sean/32/772_2.png) [@Sean](https://forums.knack.com/u/Sean)\ **Post date:** [December 1, 2022, 4:18pm UTC](https://forums.knack.com/t/released-improvements-to-workflows-that-use-date-time-fields/13431/8 "2022-12-01T16:18:39Z")
Great to see these changes in the app, very helpful! ---
**Author:** ![keith1](https://avatars.discourse-cdn.com/v4/letter/k/6de8d8/32.png) [@keith1](https://forums.knack.com/u/keith1)\ **Post date:** [December 22, 2022, 10:56am UTC](https://forums.knack.com/t/released-improvements-to-workflows-that-use-date-time-fields/13431/9 "2022-12-22T10:56:33Z")
Thank you, it would be great if we could see Weekends as an option on the date fields