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

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.

Thank you