Help with formula to extract either start or end year in timeline column

Platform discussions
, ,
1

Hi all,

I want to automate whether or not a project was worked on in a specific calendar year by using a formula - so far only finding separate commands for start or end, and when applying the formula below, I get “25” in every row of the formula column, whether or not it has a start or end year of “25.”

FORMAT_DATE({Timeline#End}, “25”)

image

2

Hello @higheredpmo You’re seeing “25” everywhere because FORMAT_DATE doesn’t support two-digit years and is just returning the text you passed in.

Use YEAR() on the Timeline instead.

End year
YEAR(Timeline#End)

Start year
YEAR(Timeline#Start)

To flag anything that happened in 2025
IF(OR(YEAR(Timeline#Start)=2025, YEAR(Timeline#End)=2025), “Yes”, “No”)

Dr. Tanvi Sachar
Monday Certified Partner, Tuesday Wizard

3

@higheredpmo ,

You are on the right track. To get the two digit year, instead of using “25” in the FORMAT_DATE() function, USE “YY”, like this:

FORMAT_DATE({Timeline#End}, "YY")

Jim - The Monday Man