Support Article
Date format is not as mentioned in properties
SA-32264
Summary
Issue1:
When user enter the date in required read only format and when focus is out from the date field, it is showing error.
Issue 2:
When user select the date from date picker, it is not showing in read only format only when focus is out from the date field it is changing to the required date format as mentioned in Presentation tab of Date Property
Error Messages
"xxxxxx is not a valid date/time value " error is thrown for issue 1 as shown below.
![](https://gcsprdsa.lab.pega.com/articles/datacontent/Image/rteImages/p51483963494398.png)
Steps to Reproduce
Have Date field with the' Allow text entry' enabled and uses Read only Custom format as shown below.
![](https://gcsprdsa.lab.pega.com/articles/datacontent/Image/rteImages/p61483963549379.png)
![](https://gcsprdsa.lab.pega.com/articles/datacontent/Image/rteImages/p71483963592058.png)
Root Cause
Works correctly as per the design.
Issue1:
When we use 'Allow text entry' configuration on the date field and when we try to enter the date, the date format entered will be checked against the locale format, hence when date is given in a format other than locale then error is thrown.
The Read only format is used to display the date in that format after selecting from the date picker calendar icon or entering the date in the locale format and then when focus is out of that field, that is why when we move the focus on the date field again (field will be in editable mode) the date will be diaplayed in the locale format itself. Issue2:Only when we focus out of a field its read only formatting will be applied to the field.
Resolution
Here’s the explanation for the reported behavior:
The two issues reported are expected, the following suggestions can be considered to avoid the issues.
Issue1:
1. To enter the date in the locale format and once the focus is outside then it converts to the read only custom format (or)
2. To avoid user entering the date by disabling by setting "Allow Text Entry" as No
Issue2:
Set "Allow Text Entry" as No in the presentation tab of the date cell properties.
Published January 10, 2017 - 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.