Skip to main content
Kofax

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

Article # 3038549 - Page views: 34

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