In SAS^® Anti-Money Laundering, the dates that are displayed in the fields of the Create Date and Run Date columns in the alert Targeted Search Results data grid are off by a day when compared to their corresponding date values in the FSK_ALERT table in the Knowledge Center database. 

There is a workaround for the Create Date column. Take the following steps:

1. Update the Apache Solr data-config.xml file for each business unit for the alert entity. Use the following format string for the Create Date column in the file:
   
   <field column="CREATE_DATE" name="create_date" dateTimeFormat="yyyy-MM-dd HH:mm:ss"/>
    
2. Save the changes for the Apache Solr data-config.xml file.
3. Reload the Apache Solr configuration.
4. Re-index the affected alert entity.

There is no workaround for the Run Date column.  

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Compliance Solutions 7.1 is available at: