User Story
Change the format of a day
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".