Snippet date format

  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I am trying to change the date format of a model field on snippet to MMDDYYYY. Is there a formating method allows me to do like this.
Photo of Kumar


  • 70 Points

Posted 2 years ago

  • 1
Photo of Conlan O'Rourke

Conlan O'Rourke

  • 4,722 Points 4k badge 2x thumb
Kumar, I would recommend using a UI-Only formula field need for a snippet to do that.

In your formula, use the following function

FORMAT_DATE( "mmddyy",{{Your_Date_Field_Here__c}} )

I use that formula all the time with various date formats (see date formatting options here), for example:

FORMAT_DATE("MM d, yy" , {{Your_Date_Field_Here__c}} )

FORMAT_TIME formula is also great in case you want to display a datetime field in a very reader-friendly manner, for example:

FORMAT_TIME("h:mm a",{{Your_Datetime_Field_Here__c}})