Capture text fields with a "T" in a date/time string are reformatted without the "T" after being saved
Article # 3038549 - Page views: 17
Issue
Why are Capture text fields with a "T" in a date/time string reformatted without the "T" after being saved?
For example, if "2021-07-25T00:00:00" is input as text field value and confirmed, the value is changed to "7/25/2021 12:00:00 AM".
Cause
This was determined to be default behavior of the JSON serializer which is part of the Windows Communication Foundation which is a part of .NET Framework.
Solution
The workaround is to apply a Business Rule formatter.
Custom code would need to be written to parse input string like “7/25/2021 12:00:00 AM” and then convert it back to “2021-07-25T00:00:00”.
Level of Complexity
Moderate
Applies to
Product | Version | Build | Environment | Hardware |
---|---|---|---|---|
KTA | 7.x |
References
Add any references to other internal or external articles
Article # 3038549