SUPPORT / SAMPLES & SAS NOTES
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 | ||