function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SquirrelMasterSquirrelMaster 

Combining LEFT and RIGHT functions in one formula

I need to see if it is possible to combine the LEFT and RIGHT functions into one formula. 

 

Example)

 

I have a date field that lists t he date in text format such as 10-10-2011.  I want a formula for a new field that will essentially populate the period this is for which would populate with 10-2011.  It would use the LEFT function for the left two values and the RIGHT function for the right four values and almost like concantonate them.  Is this possible?

 

Thanks.

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

Yeah, like this ->

LEFT(Date,2) + "-" + RIGHT(Date,4)

 

All Answers

Steve :-/Steve :-/

Yeah, like this ->

LEFT(Date,2) + "-" + RIGHT(Date,4)

 

This was selected as the best answer
SquirrelMasterSquirrelMaster

Mucho Gracias!!!!
Steve :-/Steve :-/

No problem, you owe me a cervesa (and I drink THESE!) http://beeradvocate.com/beer/profile/863/7971
SquirrelMasterSquirrelMaster

Heh, fancy beer taste you have there. Send me your paypal addy and I'll buy you a Colt 45!
Steve :-/Steve :-/

YIKES!!!  Colt.45?!?  I'd sooner drink a Haffenreffer!  (aka The Green Monster)
SquirrelMasterSquirrelMaster

Ok, what about Miller High Life?  I mean it is the champagne of beers. 
Steve :-/Steve :-/

Well it is good for smashing across the bow of a ship, so I guess it's kinda like champagne in that respect