interval date get the to value

[Former Member]

Hi experts,

I have a manual input interval variable for the object 0calday and I would like to "isolate" the "to value" because in the column section, I have a column for "period amount" and another one to "last date of the period amount".

I've tried with a formula with 2 replacement path variables in it , but without success.

Is it possible to do that with a formula or a variable in QD or, should I go with a user exit variable ??

Thanks.

[Former Member · Accepted solution]

Hi,

as I understand the issue, you want to create a text variable for

column header.

I think you should cretae a text variable and use customer exit.

sample

WHEN 'YOUR_TEXT_VARIABLE'.

IF I_STEP = 2.

LOOP AT I_T_VAR_RANGE INTO LOC_VAR_RANGE

WHERE VNAM = 'VAR_FOR_0CALDAY'.

CLEAR L_S_RANGE.

L_S_RANGE-LOW = LOC_VAR_RANGE-HIGH.

L_S_RANGE-SIGN = 'I'.

L_S_RANGE-OPT = 'EQ'.

APPEND L_S_RANGE TO E_T_RANGE.

EXIT.

ENDLOOP.

ENDIF.

'YOUR_TEXT_VARIABL represents name of created text variable, 'VAR_FOR_CALDAY' name of variable for 0CALDAY.

Hope this helps

Joe

[Former Member · Accepted solution]

Hi J.F.B.,

you gave me a good hint ...

I must "isolate" the "to value" for two purposes :

1. for the column header text like you mentioned, but I was able to do it via text variable with replacement path on 0calday...

2. for the column value, I must count how many rows I get for that "to value" ...

example

in period I get : 100 rows returned

in the last day of the period i get 10 rows returned :

but to get the 10 rows , I must made a selection on 0count and 0calday only for the last day of the period !

So, I guest you sugest me to go with user exit variable , right ?

thanks

[Former Member · Accepted solution]

Hi,

If replacement path doesn't work, I think you should try it with

an exit variable.

Regards

Joe