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?
This is working as designed. The standard Salesforce Date field values are stored in the YYYY-MM-DD format instead of MM/DD/YYYY.
Salesforce Documentation: "Date" and "Date Time" format in Data Loader and API
CRM Help Documentation: DCR Results
Send us your feedback: We're always looking for advice to help improve our Knowledge Base! Please let us know if this article was helpful or provide feedback on how we can improve your experience here.