Posts

Showing posts with the label RIGHT

Salesforce Fact #568 | Format date using RIGHT()

Image
Suppose there is a date field in the object and we want to format the date value to DD.MM.YYYY format. And also prefix 0 is to be considered for Day < 10 and also for Month  < 10.  Now, we can use IF check to implement this. However, we can append '0' and use RIGHT() function to get the result in a bit simpler way. Attached are the screenshots.