Hi,
Is there a way that I can build my label so that this year it shows FY20 and next year it will reflect FY21? Is there a formula that can make this happen so I don't have to rebuild each year?
Solved! Go to Solution.
@Anonymous
Here you go "FY"&Right(Text(Year(Now())),2)
Thanks,
Kranthi
__________________
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
@Anonymous You can try Year( Now() )
_________________
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
@Anonymous
Here you go "FY"&Right(Text(Year(Now())),2)
Thanks,
Kranthi
__________________
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
User | Count |
---|---|
252 | |
107 | |
88 | |
51 | |
44 |