# Can we add add a entire year into a trigger action

**URL:** https://community.glideapps.com/t/can-we-add-add-a-entire-year-into-a-trigger-action/44401
**Category:** Ask for Help
**Created:** [July 13, 2022, 1:03pm UTC](https://community.glideapps.com/t/can-we-add-add-a-entire-year-into-a-trigger-action/44401 "2022-07-13T13:03:13Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [July 13, 2022, 1:38pm UTC](https://community.glideapps.com/t/can-we-add-add-a-entire-year-into-a-trigger-action/44401/4 "2022-07-13T13:38:19Z")

</div>

hmm, if you want to use that to do a Set Column value on an existing date/time column you’ll probably find that it doesn’t work.

So perhaps the below will be a better option in your case:

> [@Glide Editor screen goes blank when using Math Column](https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646/15):
>
> Edit: I have some updates to this formula that I’ve explained in the post below. You’re requirement to back Feb 29th by a day if it’s not a leap year does complicate it a bit, but that’s not a problem. It just makes for a formula that’s much larger. Here is the formula if we were to allow Feb 29th to roll over to Mar 1st. ((Now-DAY(Now)+15)+(Years\*365.25)) - DAY((Now-DAY(Now)+15)+(Years\*365.25)) + DAY(Now) ‎ ‎ ‎ ‎ ‎ To get the leap year date of Feb 29th to back date to Feb …

You’ll just need to decide what happens if todays date is Feb 29 😉

---

_[View the full topic](https://community.glideapps.com/t/can-we-add-add-a-entire-year-into-a-trigger-action/44401)._