Skip to content

Instantly share code, notes, and snippets.

@swapnilshrikhande
Created March 24, 2017 06:41
Show Gist options
  • Save swapnilshrikhande/a41b73ace58a35ef13700fea18b40642 to your computer and use it in GitHub Desktop.
Save swapnilshrikhande/a41b73ace58a35ef13700fea18b40642 to your computer and use it in GitHub Desktop.
sf ddMMyyyyformatedformula
IF( DAY(Invoice_Date__c)<10,'0','' )
& TEXT(DAY(Invoice_Date__c))
&'/'&
IF( MONTH(Invoice_Date__c)<10,'0','' )
& TEXT(MONTH(Invoice_Date__c))
&'/'&
TEXT(YEAR(Invoice_Date__c))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment