Conditions: Variables on date key figures

[Former Member]

Dear Sirs,

I am trying to create a condition on a key figure of type date (subtype: dats). I want the user to select a date interval for this condition, using variables.

The problems seems to be that the variable input screen thinks the user should enter an amount and not a date. If I enter a date in the variable then no data is beeing displayed.

So how can I get the variable to understand that the input is a date ?

Has anyone done what I try to do sucessfully.

[former_member189638 · Accepted solution]

Assuming that you are using the variable created under a date parameter(e.g 0CALDAY) as an input in the selection screen. Don't create any variable for this and don;t use it in seletion screen

Instead create a Formula variable of processing type as Replacement Path and replace it wil the 0CALDAY. Make it ready for input. So that will be available in the selection acreen. Also you can use this for creating condition.

[Former Member · Accepted solution]

Hello Rakesh,

thanks for your input. However, I am not able to get it to work.

I create a condition on the key figure "date". I use e.g greater than. Then create a variable with replacement path to 0CALDAY, and transfer the condition.

When I run the report I get the following error.

Termination message sent

ABEND BRAIN (418): Variable VAR_20080128112329 (D2LEOFV2P3JFW0YWPGXBKJ53A) does not exist or is incorrectly used 4 D2LENS95OIB2G5DTW28S323D2

MSGV1: VAR_20080128112329

MSGV2: D2LEOFV2P3JFW0YWPGXBKJ53A

MSGV3: 4

MSGV4: D2LENS95OIB2G5DTW28S323D2

Have you managed to solve the excact same requirement?

regards,

Jørgen

[Former Member · Accepted solution]

Hello,

I am still not able to get this to work. Can anyone confirm if they have solved the same issue, so I know it is feasible, and just me doing something wrong.

I have a key figure of type date, DATS. I want to create a condition on this key figure, where the user type in a date range e.g 01.01.2000 - 01.01.2002, using variables.

Possible?

best regards,

Jørgen