+ 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"