Skip to main content

I have a single table with 2 varying date formats, one that is in date format (i.e. 6/30/2025) and another one with single select (i.e. 2025). I’m trying to figure out a way to link the two together, that way when I update the actual date, the year updates accordingly. A lot of times we have multiple people working on the same table, and they update the date column, but not the year. Simplifying this to where the year updates automatically would allow us to keep things consistent. Any help would be greatly appreciated! 

Hey ​@CTOldsmobile for the reasons described, that is exactly why you do not want to have two different freely modifiable fields to this effect :D

The way in which you’ll want to structure this:
Date filed (as you already have)
Formula field (replacing your single select).

The formula that you’ll want to youse is:
 

YEAR({Date Field Name})


Please feel free to schedule a call if you need any additional help.

Mike, Consultant @ Automatic Nation


Forgot to mention end result:

If Date field is 6/30/2025, Formula field will automatically show 2025

In this way, your team would only need to edit one unique field.

Mike, Consultant @ Automatic Nation


Thank you @Mike_AutomaticN! I appreciate the help, I’ll get working on implementing this! 


Thank you @Mike_AutomaticN ! I’ll get working on implementing this!


Reply