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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.