
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 21, 2019 11:26 AM
Hi all,
I’m trying to write a formula for the following:
I’d like a Field that shows me if a date (which I have, based on a formula in an adjacent field) is in 2019, then this field should be “yes”. I’m struggling to get that to work. Would love any help out there.
Thanks!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 21, 2019 11:48 AM
This should be what you need:
IF(YEAR(Date)=2019,“Yes”,“No”)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 21, 2019 12:20 PM
Thank you, Julian, but that did not work.
Two things, I think.
- The Yes or No should be an answer to if another Field has a 2019 date
- The Contract End Date Field that #1 above is referencing is a formula DATEADD({Contract Start Date},1,‘y’), so is it even possible for the formula in the Yes/No field to pull only the year?
Additionally, a simpler way to do this may be just a Field column with Renewal Year (which I’d then group or link to another table). Is there a formula that will pull just the year from Contract End Date (a formula field) and have that as the fill for the record in that field?
Thank you
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 21, 2019 01:27 PM
Hi @Zeke_Fraint - I think @Julian_Kirkness’s answer works, might just be the way you’re translating his answer to your base. It looks like you’ve got this:
As per Julian’s answer the 2019? field formula is:
IF(YEAR({Contract End Date})=2019,'Yes','No')
Presumably, you want to know when the contract end date is in “this year” rather than just 2019? If so, you could extend the formula thus:
IF(YEAR({Contract End Date})=YEAR(TODAY()),'Yes','No')
The “This Year?” column will work in 2020, 2021 and so on without any changes.
JB

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 21, 2019 01:53 PM
Wow, @JonathanBowen thank you. Both of those are exactly correct. Thank you so much to you and @Julian_Kirkness. Much appreciated!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 21, 2019 02:03 PM
Can I link to another table (like a pivot) from this 2019 Renewal field? @Julian_Kirkness @JonathanBowen
