You need to sign in to do that
Don't have an account?
LeeC
Display Years from two date fields
Hello, I have two date fields and I would like to display just the two years seperated by a -
e.g.
Date 1 = 1/1/2010
Date 2 = 2/2/2020
Formula Displays = "2010 - 2020"
Thanks in advance
Here you go
DataType: Formula(Text)
Formula:
TEXT(YEAR(Date_1__c)) + " - " + TEXT(YEAR(Date_2__c))
PS. You owe me a beer!
http://www.russianriverbrewing.com/web/brews/plinytheelder.htm
All Answers
Here you go
DataType: Formula(Text)
Formula:
TEXT(YEAR(Date_1__c)) + " - " + TEXT(YEAR(Date_2__c))
PS. You owe me a beer!
http://www.russianriverbrewing.com/web/brews/plinytheelder.htm
Thank you! works a treat.
I will post you the beer :-)