+ Start a Discussion
Kaiti Boling 13Kaiti Boling 13 

Can we create a validation rule to check that a date field is displayed in the following format? MM/DD/YYYY

Sagar PatilSagar Patil
Hi Kaiti,

Please refer below link.
https://success.salesforce.com/answers?id=9063A000000e6DrQAI

Kindly mark this answer as best answer if it helps you. 

Regards,
Sagar
Manoj DeshmukhManoj Deshmukh
Hi Kaiti,

Already Salesforce prevents you from filling in a Date that is in the wrong format. If your org has dates in the format (MM/DD/YYY) and you attempt to put in 30 April 1900 as (30/04/1900) you will get an error, and you will be forbidden.

But if you attempt to put 5 April 1900 as (05/04/1900) then Salesforce will accept the data, even though it is not the appropriate date. There is no validation rule that could fix this issue, as there is no problem with data entry itself.

Kindly mark this answer as best answer
Regards
Manish
kamala swarnalathakamala swarnalatha
Hi,

We cannot create validation rule to check that a date field is displayed in the following format? (MM/DD/YYYY).
Because salesforce store the date in the format (MM/DD/YYYY) so we can't able to create validation rule for this.
Please refer below link.To verify this
https://help.salesforce.com/articleView?id=mc_es_data_extension_data_types.htm&type=5

Hope this helps!
Thanks,
Kamala
Sweet Potato Tec.