Using Date and Date/Time in Formulas - Salesforce

For details on how to convert between Date values and Date/Time values, see Converting Between Date/Time and Date on page 2. The DATE() Function ... This returns the date in the format “YYYY-MM-DD” rather than in the locale-dependent format. You can change the format by extracting the day, month, and year from the date first and then ... ................
................