Problem Note 69241: You are unable to extract the correct date range of data from a SAS® Anti-Money Laundering Cash Flow Fact table
 |  |  |  |  |
The date range of data extracted from the Cash Flow Fact (FSC_CASH_FLOW_FACT) does not correspond to the specified start and end dates.
This issue occurs because the following filter condition that is used in the underlying SQL query code is incorrect:
("&start_date"d - datepart(cff.transaction_dttm) < "&end_date"d)
The correct condition is as follows:
("&start_date"d <= datepart(cff.transaction_dttm) < "&end_date"d)
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Linux for x64 | 8.3 | Viya | ||
An update for this issue is available for SAS Compliance Solutions 8.3. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/ComplianceSol_83_home.html#69241| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2023-06-21 12:19:35 |
| Date Created: | 2022-05-26 14:08:03 |