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

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

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#63545

---

A 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