Lesson: 02 | Formatted Date

Expectation

 The formatted date must be like 2023-1-29

Code

TEXT(YEAR(Your_Date__c))+"-"+
TEXT(MONTH(Your_Date__c))+"-"+
TEXT(DAY(Your_Date__c))

Explanation

This formula is used to format a date field as text in the form of "YYYY-MM-DD".

The YEAR function extracts the year component of the date stored in the "Your_Date__c" field. The MONTH function extracts the month component, and the DAY function extracts the day component.

The TEXT function is used to convert the numerical values for year, month, and day into text, so that they can be concatenated with the hyphens (-) in between. The result is a text string in the format "YYYY-MM-DD".

Video