Capture text fields with a "T" in a date/time string are reformatted without the "T" after being saved

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