# Date from Date Components - like Excel's: DATE (year, month, day)

**URL:** <https://forums.knack.com/t/date-from-date-components-like-excels-date-year-month-day/6467>\
**Category:** Feature Requests\
**Created:** [June 11, 2019, 2:41pm UTC](https://forums.knack.com/t/date-from-date-components-like-excels-date-year-month-day/6467 "2019-06-11T14:41:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MichaelImp73688](https://avatars.discourse-cdn.com/v4/letter/m/ea5d25/32.png) [@MichaelImp73688](https://forums.knack.com/u/MichaelImp73688)\
**Post date:** [June 11, 2019, 2:41pm UTC](https://forums.knack.com/t/date-from-date-components-like-excels-date-year-month-day/6467/1 "2019-06-11T14:41:00Z")

</div>

Although there are workarounds involving Text Formulas and the excellent text-based "formatDate" function, it would be really helpful if there was a function that could be used in Equations which would create a native date from date components.

Excel has this function, with syntax "DATE (year, month, day)".

I primarily want this to calculate the first day of the month without resorting to text formulas, but I think it would be relatively simple to implement and a useful generic date function.

---

<div class="post-metadata">

**Author:** ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)\
**Post date:** [July 27, 2023, 10:44pm UTC](https://forums.knack.com/t/date-from-date-components-like-excels-date-year-month-day/6467/2 "2023-07-27T22:44:29Z")

</div>

Agreed.