# Compute next first of year

**URL:** https://forums.knack.com/t/compute-next-first-of-year/19374
**Category:** Get Answers
**Created:** [May 24, 2025, 12:36pm UTC](https://forums.knack.com/t/compute-next-first-of-year/19374 "2025-05-24T12:36:21Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![vidierre](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/vidierre/32/4539_2.png) [@vidierre](https://forums.knack.com/u/vidierre)
#### Post date: [May 24, 2025, 12:36pm UTC](https://forums.knack.com/t/compute-next-first-of-year/19374/1 "2025-05-24T12:36:21Z")

</div>

I have an associates table with a Date/Time field named **subscribed\_on**  
Now I would like to add a second field named **expire\_on** that has to be the first of Jan of the year following the one the associate asked to subscribe.

I was thinking to use an equation field but I found no way to build the new date (the classic EXCEL DATE() function).  
There are functions like getDate_xxx_ but nothing to build a date I miss something?

---

<div class="post-metadata">

### Author: ![LeighBerre96926](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/leighberre96926/32/4896_2.png) [@LeighBerre96926](https://forums.knack.com/u/LeighBerre96926)
#### Post date: [May 24, 2025, 1:25pm UTC](https://forums.knack.com/t/compute-next-first-of-year/19374/2 "2025-05-24T13:25:35Z")

</div>

Here is a bit of a round about way of doing it, but it works. Create 3 additional fields as below:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/9/9caae729c6744323837edb9c147654bcf0b77c21.png)

RENEW Year is an equation as below. Make sure you pick NUMERIC even though you are using dates, or it doesn’t work. This gives you the following year.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/7/7a66329972af48b4f252ca13f2d8c7b0b3989e6b.png)

The Text Formula simply builds out the 1/1/XXXX string:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/2/24f59ed21a335d30dc401be32ffd2d642af30fb6.png)

Then RENEW DATE turns that string into a useable date, using a conditional rule:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/e/e5d0a9fdc04039939f006cdbe3e052dbe8dbedbd.png)

A bit messy, and maybe someone else knows how to streamline this, but its functional and doesn’t require any special code or tricks …

---

<div class="post-metadata">

### Author: ![vidierre](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/vidierre/32/4539_2.png) [@vidierre](https://forums.knack.com/u/vidierre)
#### Post date: [May 24, 2025, 7:00pm UTC](https://forums.knack.com/t/compute-next-first-of-year/19374/3 "2025-05-24T19:00:15Z")

</div>

Thank you @LeighBerre96926 I will try it, even if I am afraid that in this way we cannot compare the values.  
i.e. chek if in the next 30 days someone needs to be renewed…

---

<div class="post-metadata">

### Author: ![LeighBerre96926](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/leighberre96926/32/4896_2.png) [@LeighBerre96926](https://forums.knack.com/u/LeighBerre96926)
#### Post date: [May 24, 2025, 9:50pm UTC](https://forums.knack.com/t/compute-next-first-of-year/19374/4 "2025-05-24T21:50:33Z")

</div>

Yes you can. The final field is a fully usable date field that will be able to be reported on, filtered, or used as a trigger in tasks just like any other date field.

---

<div class="post-metadata">

### Author: ![LeighBerre96926](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/leighberre96926/32/4896_2.png) [@LeighBerre96926](https://forums.knack.com/u/LeighBerre96926)
#### Post date: [May 24, 2025, 9:52pm UTC](https://forums.knack.com/t/compute-next-first-of-year/19374/5 "2025-05-24T21:52:02Z")

</div>

Just set up a view filtered by renew date is today, before today or in the next 30 days…