# Reference END DATE of a Date/Time Field Please!

**URL:** <https://forums.knack.com/t/reference-end-date-of-a-date-time-field-please/11999>\
**Category:** Feature Requests\
**Tags:** equation-field, workaround-available\
**Created:** [February 5, 2022, 3:46am UTC](https://forums.knack.com/t/reference-end-date-of-a-date-time-field-please/11999 "2022-02-05T03:46:42Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![RealEyesDisplays](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/realeyesdisplays/32/1444_2.png) [@RealEyesDisplays](https://forums.knack.com/u/RealEyesDisplays)\
**Post date:** [February 5, 2022, 6:54pm UTC](https://forums.knack.com/t/reference-end-date-of-a-date-time-field-please/11999/3 "2022-02-05T18:54:56Z")

</div>

Yes, as stated in my post above, there is a way to extract the end date in a formula. However, you must set your formulas into another Date/Time field in order to perform any record filtering with them. You cannot filter records based on a formula.

Because of this, your formulas break down when the user decides to select a Single day event, ALL DAY, and furthermore, ALL DAY with repetition or multi-day. There is too much variation for these text-based formulas to work.

With some custom code and additional fields, you can control the date format and extract the end date with formulas, then set another Date/Time field to the end date based on a formula. Then you can finally use that field to perform end-date filtering on your records.

All of this complexity and extra work…just to allow a multi-day event to show up in Today’s Events list!

So I guess the feature request would either be - allow end date to be easily extracted for all user choices (such as use of the [Date Formatter function](https://learn.knack.com/article/z2uiemxq8t-text-formula-functions)), OR fix the Date/Time field and the calendar view so that Multi-day and repetitive events show up when filtering by days other than their start date.

Hope that helps clarify what’s needed here.

---

_[View the full topic](https://forums.knack.com/t/reference-end-date-of-a-date-time-field-please/11999)._