topic Re: Dynamic Date Calculation for Current Date - 1 in Application Development and Automation Discussions

Dynamic Date Calculation for Current Date - 1

Former Member — Fri, 23 Feb 2007 13:40:52 GMT

I am trying to create a variant with a dynamic date calculation attribute.

I am following the instructions as they are posted to the web but I get an error message.

I want to get all data EQ to the current date -1

In the object for selection screen I enter a D for Selection Variable, for Name of Variable I enter an I to include specific values and the option EQ for current date +/- ??? days. Then I enter 1- for the number of days. I have tried to enter this many times and in many ways but it doesn't work. I keep getting this message "lower limit of interval is greater than upper limit"

Re: Dynamic Date Calculation for Current Date - 1

amit_khare — Fri, 23 Feb 2007 13:48:58 GMT

Hi,

Welcome to SDN.

Selection-screen has four values -

SIGN

OPTION

LOW

HIGH

Pass your date value in the option low for the screen.

Sign you have already pass as I and option as EQ.

Regard,

Amit

Reward all helpful replies.

Can you paste your code here.

Message was edited by:

Amit Khare

Re: Dynamic Date Calculation for Current Date - 1

Former Member — Fri, 23 Feb 2007 14:53:08 GMT

Hi Amit,

Thanks for answering my post. But I don't quite understand. Where are the four values SIGN, OPTION, LOW, HIGH. How do I select LOW.

Thanks

Re: Dynamic Date Calculation for Current Date - 1

Former Member — Fri, 23 Feb 2007 14:59:18 GMT

Hi,

The error message you are getting is because the value in the LOW option of the select-option is greater than the value in the HIGH option.

Check if you are giving any value in the HIGH option before the execution of the program.

Regards,

Ravi.

Re: Dynamic Date Calculation for Current Date - 1

Former Member — Fri, 23 Feb 2007 15:01:34 GMT

Hi Carolyn,

Please type -1 for parameter.

For select-option, please enter 'I' (I/E field) and

EQ (option field) then enter -1.

Regards,

Ferry Lianto

Re: Dynamic Date Calculation for Current Date - 1

Former Member — Fri, 23 Feb 2007 15:03:03 GMT

Hi Carolyn,

try this:

TABLES: BKPF.

PARAMETERS: P_DATE LIKE SY-DATUM.

SELECT-OPTIONS: S_DATE FOR BKPF-BUDAT.

INITIALIZATION.

P_DATE = SY-DATUM - 1.

S_DATE-LOW = SY-DATUM - 1.

S_DATE-SIGN = 'I'.

S_DATE-OPTION = 'EQ'.

APPEND S_DATE.

You can use parameters or select-options as you need.

Regards, Dieter

Re: Dynamic Date Calculation for Current Date - 1

Former Member — Fri, 23 Feb 2007 15:04:01 GMT

select-options : date for mkpf-budat.

initialization.

date-sign = 'I'.

date-option = 'BT'. " between EQ equal ....

date-low = '20070201'.

date-high = '20070101.

*high must be greater than low

append date.

Re: Dynamic Date Calculation for Current Date - 1

natasha_baunach — Tue, 06 Mar 2007 00:06:16 GMT

Carolyn,

Please apply OSS note Note 990695 - Dynamic date calculation, DB 274, which should also apply the prereq Note 956480 (fix for negative values).

Natasha

Re: Dynamic Date Calculation for Current Date - 1

Former Member — Tue, 06 Mar 2007 16:41:01 GMT

Hi Carolyn,

You could try to apply the OSS note 970999, this note fixes problems with negative number in dynamic date calculation.

Regards.

Re: Dynamic Date Calculation for Current Date - 1

Former Member — Tue, 06 Mar 2007 16:55:43 GMT

Hi ,

when u save the variant click the varaiable as L Selection variable and press the

selection variable push buttom .

there u see the variable where DATE is shown press in T DBL click and select + or -

when u select this come out of the screen by saving .

then select the variant u wll c the ur data will be + or - what u want to give.

Rewards points.