Problem Note 63545: Spreadsheet cell values that depend on a date do not resolve correctly in SAS® Risk and Finance Workbench
 |  |  |  |  |
When you use the following functions in spreadsheets, the returned value is a string and not a date in SAS® Risk and Finance Workbench:
- _OG("DATE")
- _OG("PROJECT_AS_OF_DATE")
This issue results in dates not resolving properly for cell values.
There are no warnings or errors.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Risk and Finance Workbench | Microsoft® Windows® for x64 | 3.1 | 9.4 TS1M5 | ||
| Linux for x64 | 3.1 | 9.4 TS1M5 | ||||
A fix for this issue for SAS Risk and Finance Workbench 3.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D4L.html#63545A fix for this issue for SAS Risk and Finance Workbench 3.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C5N.html#63545
In SAS® Risk and Finance Workbench, if you use the _OG("DATE") and
_OG("PROJECT_AS_OF_DATE) functions, the returned value is a string instead of a date. This behavior results in dates not resolving properly for cell values.
| Type: | Problem Note |
| Priority: | alert |
| Topic: | Analytics ==> Financial Analysis |
| Date Modified: | 2019-03-01 13:03:59 |
| Date Created: | 2019-01-24 11:25:54 |