# Date Equation - change result after hard-coded date of each year

**URL:** https://forums.knack.com/t/date-equation-change-result-after-hard-coded-date-of-each-year/9192
**Category:** Get Answers
**Created:** [December 7, 2019, 5:03pm UTC](https://forums.knack.com/t/date-equation-change-result-after-hard-coded-date-of-each-year/9192 "2019-12-07T17:03:31Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![jintak04186](https://avatars.discourse-cdn.com/v4/letter/j/22d042/32.png) [@jintak04186](https://forums.knack.com/u/jintak04186)
#### Post date: [December 7, 2019, 5:03pm UTC](https://forums.knack.com/t/date-equation-change-result-after-hard-coded-date-of-each-year/9192/1 "2019-12-07T17:03:31Z")

</div>

Hi!

&nbsp;

I'd like to add a field - say "Expiry" - which has a logic such that, if _Joining date_ is this year and _Joining date_ is after 1 Oct, then the "Expiry" would be 1 Apr Year+2, while if _Joining date_ is before 1 Oct, then "Expiry" would be 1 Apr Year+1. &nbsp;For all other years, the "Expiry" would be 1 Apr Year+1.

&nbsp;

Trying to use Conditional Rules, but can such a rule be applied?

---

<div class="post-metadata">

### Author: ![Sunny\_Singla](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sunny_singla/32/1007_2.png) [@Sunny\_Singla](https://forums.knack.com/u/Sunny_Singla)
#### Post date: [December 16, 2019, 5:25am UTC](https://forums.knack.com/t/date-equation-change-result-after-hard-coded-date-of-each-year/9192/2 "2019-12-16T05:25:48Z")

</div>

Hi Jin

Try below&nbsp;

First add 93 days in joing date -\> field\_x (formula field )  
  
then add 1 year in new field\_x -\> field\_y (formula field )

take year from field\_y-\> field\_z

and make Apr-1 -field\_z(expiry field)&nbsp;

&nbsp;

Regards,

Sunny Singla

[ssingla1985@gmail.com](mailto:ssingla1985@gmail.com)

+919855089359&nbsp;