# Getting the 1st day of the year

**URL:** <https://forums.knack.com/t/getting-the-1st-day-of-the-year/10070>\
**Category:** Get Answers\
**Created:** [March 27, 2017, 5:37pm UTC](https://forums.knack.com/t/getting-the-1st-day-of-the-year/10070 "2017-03-27T17:37:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![LauraFinne52981](https://avatars.discourse-cdn.com/v4/letter/l/ecc23a/32.png) [@LauraFinne52981](https://forums.knack.com/u/LauraFinne52981)\
**Post date:** [March 27, 2017, 5:37pm UTC](https://forums.knack.com/t/getting-the-1st-day-of-the-year/10070/1 "2017-03-27T17:37:03Z")

</div>

I'd like to be able to calculate interest paid over the course of a year and in order to do so I need a start date of January 1 for the given year. &nbsp;Has anyone figured this out?

---

<div class="post-metadata">

**Author:** ![LauraFinne52981](https://avatars.discourse-cdn.com/v4/letter/l/ecc23a/32.png) [@LauraFinne52981](https://forums.knack.com/u/LauraFinne52981)\
**Post date:** [March 27, 2017, 9:44pm UTC](https://forums.knack.com/t/getting-the-1st-day-of-the-year/10070/2 "2017-03-27T21:44:33Z")

</div>

Thanks. &nbsp;Worked great!

---

<div class="post-metadata">

**Author:** ![MGR](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/mgr/32/2249_2.png) [@MGR](https://forums.knack.com/u/MGR)\
**Post date:** [March 27, 2017, 8:28pm UTC](https://forums.knack.com/t/getting-the-1st-day-of-the-year/10070/3 "2017-03-27T20:28:17Z")

</div>

_Hi Laura,_

_Coincidentally I just needed to do that on my app a couple days ago. You just need a text formula with the following:_

_1/1/getDateYear({Name of the Date Field})_

_That field will be just text, and you probably need it to be an actual date, so you need a second field of the type date. On this second field you just need to set a conditional rule that makes it always equal to the first field.&nbsp;_

_And I think this will give you what you need. Just get sure that the second field is UNDER the first field, because fields are calculated from top to bottom.&nbsp;_

_Cheers to Sam for helping me with this when I needed it :)_
