Problem Note 59135: "ERROR:Invalid date/time/datetime constant "today()"" might occur after the promotion of a new product forecast project
 |  |  |  |  |
In SAS® Forecast Analyst Workbench, the following error might occur after you create a new product forecasting plan and then promote the new product forecast project:
ERROR:Invalid date/time/datetime constant "today()"
The error occurs when you set the GL_Forecast_Date global setting to today() after creating the new product forecasting plan.
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 Forecast Analyst Workbench | Microsoft® Windows® for x64 | 5.3 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 5.3 | 9.4 TS1M3 | ||||
| Linux for x64 | 5.3 | 9.4 TS1M3 | ||||
A fix for this issue for SAS Forecast Analyst Workbench 5.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A2D.html#59135
When choosing the option of "today" as your GL_Forecast_Date in New Product Forecasting in SAS® Forecast Analyst Workbench you get an error in forecasting
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-10-12 10:01:30 |
| Date Created: | 2016-10-10 15:12:25 |