problem with defaulted date but only in workbook
I have a weird date problem here. One of my queries has a "key date" which I default to the current date in the variable user exit. When I run the query, it works fine. However, when we run the workbook, things go wrong. With my date settings (DD.MM.YYYY), there is no issue, but the end users all have the American date setting (MM/DD/YYYY). Whenever one of them runs the workbook, we get an error before the variable screen is shown. The error message is as follows:
Please enter value in permitted format for variable Key Due Date.
Value "" for variable "" is invalid.
Program error in class SAPMSSY1 method: UNCAUGHT_EXCEPTION
System error in program CL_RSR_XLS_WORKBOOK and form SERIALIZE: 01 (see long text)
As soon as I change the end user's date settings, the workbook runs fine.