You need to sign in to do that
Don't have an account?
dietcola
change date to MM/DD/YYYY format in formula editor
Hello, all-
One of my field updates uses the TEXT(Date__c) function to convert the date into text. It prints it in the YYYY-MM-DD format, though, which means it's the only date in our entire Salesforce system that is not in the MM-DD-YYYY format.
Is there a way to customize that within the formula editor?
You're all life-savers; thank you as always!
Woo-hoo! This is the best forum day ever.
I had to make one tweak and remove the DATEVALUE part, which I'm just posting in case anyone ever needs to refer to this forum in the future. All credit to shillyer/Sati, though. =)
TEXT(MONTH(Date__c))+"/" +TEXT(DAY(Date__c))+"/" +TEXT(YEAR(Date__c))
Thanks so much!!
All Answers
Try this:
TEXT(MONTH(DATEVALUE(Date__c)))+"/" +TEXT(DAY(DATEVALUE(Date__c)))+"/" +TEXT(YEAR(DATEVALUE(Date__c)))
Hope that helps,
Sati
Woo-hoo! This is the best forum day ever.
I had to make one tweak and remove the DATEVALUE part, which I'm just posting in case anyone ever needs to refer to this forum in the future. All credit to shillyer/Sati, though. =)
TEXT(MONTH(Date__c))+"/" +TEXT(DAY(Date__c))+"/" +TEXT(YEAR(Date__c))
Thanks so much!!
IF( LEN(TEXT(MONTH(date__c))) > 1 , TEXT(MONTH(date__c)), "0" + TEXT(MONTH(date__c))) + "-" + IF(LEN(TEXT(DAY(date__c))) > 1 , TEXT(DAY(date__c})), "0" + TEXT(DAY(date__c))) + "-" + TEXT(YEAR(date__c))
I find the solution looking for it here :)
LPAD(TEXT(MONTH (date__c)),2,"0")&"/ "&LPAD(TEXT(DAY (date__c)),2,"0")&"/"&TEXT(YEAR(date__c))
I did remove the extra space after ther first forward slash.
LPAD(TEXT(MONTH (date__c)),2,"0")&"/"&LPAD(TEXT(DAY (date__c)),2,"0")&"/"&TEXT(YEAR(date__c))
ferenik
BEST ANSWER (imho)
Now it should be
LPAD(TEXT(MONTH (date__c)),2,"0")&"/ "&LPAD(TEXT(DAY (date__c)),2,"0")&"/"&TEXT(YEAR(date__c))
This was huge for my project!!! I have been scowering search engines for a way to get DataLoader to spit out MM/DD/YYYY format, and being that the original question was for MM/DD/YYYY and not M/D/YYYY, it should be the BEST ANSWER. I respect the first, but this is not complicated as everything resists issues I thought we all worked to solve at the turn of the 21st century with Y2K. Not even Excel will convert to this format without special coding. Zero's are super duper important. It's nuts!!!
IF(ISBLANK( date__c), NULL, LPAD(TEXT(MONTH (date__c)),2,"0")&"/"&LPAD(TEXT(DAY (Date_of_Loss__c)),2,"0")&"/"&TEXT(YEAR(date__c)))
IF(ISPICKVAL(Account.Division__c,"Access Perks"), LPAD(TEXT(MONTH (Account.Launch_Date__c)),2,"0")&"/ "&LPAD(TEXT(DAY (Account.Launch_Date__c)),2,"0")&"/"&TEXT(YEAR(Account.Launch_Date__c))
I need to pull the date if the picklist = Access Perks. I had it working but my date as yyyy/mm/dd
Here, In TEXT(TODAY()) I'm getting date format in YY/DD/MM but i want to give date format as MM/DD/YY Format & below is my formula field.
TEXT(TODAY())& " " &':'& " "&[Contact].XYZ__c & BR() &
PRIORVALUE([Contact].XYZ__c )
Thanks in advance!
2023 and still working!