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
EsteeEstee 

display opp created date as MMDDYYYY

I did

 

(TEXT(CreatedDate)

 

to get the date to display: 2009-03-29 13:17:30

 

I then used the LEFT function to get only the date

 

LEFT(TEXT(CreatedDate)),10)

 

2009-03-29

 

But I want 03292009.

 

How can I do this?? I tried TRIM, but that only removes spaces and tabs. And I cant see how to set the date to do MMDDYYYY

 

My final formula displays: LEFT(TRIM(TEXT(CreatedDate)),10)

Best Answer chosen by Admin (Salesforce Developers) 
shillyershillyer

Use this formula (type = text):

 

 

TEXT(MONTH(DATEVALUE(CreatedDate)))
+TEXT(DAY(DATEVALUE(CreatedDate)))
+TEXT(YEAR(DATEVALUE(CreatedDate)))
 
Hope that helps,
Sati 
 


All Answers
gm_sfdc_powerdegm_sfdc_powerde
I don't think there is a date formula for formatting.  One thing you can do is to concatenate MONTH(date), DAY(date) and YEAR(date).


shillyershillyer
Use this formula (type = text):
 
 
TEXT(MONTH(DATEVALUE(CreatedDate)))
+TEXT(DAY(DATEVALUE(CreatedDate)))
+TEXT(YEAR(DATEVALUE(CreatedDate)))
 
Hope that helps,
Sati 
 
This was selected as the best answer
EsteeEstee
thanks! that'll have to do! :-D
 
"3292009"