cancel
Showing results for 
Search instead for 
Did you mean: 

problem with defaulted date but only in workbook

Former Member
0 Kudos

Hi all,

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.

Any clue?

RafB

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

seems to be linked to user specific date settings... pretty weird as SAP should automatically convert according to the user settings