Support Article
Input Text dd/MM/yyyy displays error for Date field
SA-89742
Summary
On configuring a Date control and entering a date in the dd/MM/yyyy format instead of selecting it from the Calendar control, Validation error displays.
Error Messages
Invalid date format
Steps to Reproduce
- Configure a Date field.
- Set a custom format as 'dd/MM/yyyy'.
- Enter an input value as 'dd/MM/yyyy' from the keyboard instead of the Calendar control.
Root Cause
An issue in the custom application code or rules.
The Date field accepts the locale Date format only when the date is entered using the keyboard instead of selecting it from the control. For US locale, the Date format is MM/dd/yyyy. For different locales, different Date formats are accepted.
Resolution
Here’s the explanation for the reported behavior:
When a date entered is in the dd/MM/yyyy format and the local acceptable format is MM/dd/yyyy, the 'dd' value is considered as 'MM' and the 'MM' value should not exceed beyond 12. This caused the Validation error.
Perform the following local-change:
- Configure a tooltip for that particular Date field by entering a tooltip value in the Cell properties.
- Mention the acceptable format in the tooltip.
Published October 15, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.