Question:
A user sends a Data Change Request (DCR) for a Date field, and enters the value in MM/DD/YYYY format as follows:
However, the Data Change Request Line shows the value in YYYY-MM-DD, and only the localized value shows it in the original format:
What is the reason behind this date format difference?
Answer:
This is working as designed. The standard Salesforce Date field values are stored in the YYYY-MM-DD format instead of MM/DD/YYYY.
Related Documentation:
Salesforce Documentation: "Date" and "Date Time" format in Data Loader and API
CRM Help Documentation: DCR Results
Thank you