Help

RIGHT() - Last 2 digits of Created time (year)

Topic Labels: Formulas
Solved
Jump to Solution
1856 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Callery
6 - Interface Innovator
6 - Interface Innovator

Is it possible to get the last 2 digits of the creation date (year) e.g. 20 for 2020 19 for 2019.

This is to use in a unique reference field (first 2 letters of name + “-” + last two letters of creation year + “-” + Auto ref number)

I currently have:
UPPER( LEFT(Created By,2)) & “-” & ( YEAR(CREATED_TIME()) & “-” & {Project Ref}
Which gives me:
E.g. AA-2020-101

Where do I insert the RIGHT(XX,2)?

I’ve tried the following but with a returned #error!:
UPPER( LEFT(Created By,2)) & “-” & RIGHT( ( YEAR(CREATED_TIME()),2) & “-” & {Project Ref}

1 Solution

Accepted Solutions
Rey_Crisostomo
6 - Interface Innovator
6 - Interface Innovator

Try using this to get the last 2 digits of the year:
MOD(YEAR(CREATED_TIME()), 100)

See Solution in Thread

2 Replies 2
Rey_Crisostomo
6 - Interface Innovator
6 - Interface Innovator

Try using this to get the last 2 digits of the year:
MOD(YEAR(CREATED_TIME()), 100)

Scott_Callery
6 - Interface Innovator
6 - Interface Innovator

Perfect! thanks so much @Rey_Crisostomo