topic Dynamic Date with Range- Changing only High value in Application Development and Automation Discussions

Dynamic Date with Range- Changing only High value

former_member337802 — Tue, 12 Sep 2017 05:35:23 GMT

Dear SAP guys,

I am trying to give a range of values dynamically for the date field in a variant but I have been unsuccessful. My requirement is that I have to fix the low value a constant and only change high value with respect to current date. I am not able to modify only High value.

For example, in the attached picture dynamic-date.jpg, the low value I need to keep the same as 24.06.2011 but the high value 12.09.2017 needs to be changed according to current date. Please let me know your valuable inputs.

Thanks & Regards,

Aswath.

Re: Dynamic Date with Range- Changing only High value

Former Member — Tue, 12 Sep 2017 06:27:04 GMT

Hi,

Something like this :

REPORT ytestsele.

SELECT-OPTIONS dat FOR sy-datum DEFAULT '20010101' TO sy-datum NO-EXTENSION.

AT SELECTION-SCREEN OUTPUT.
LOOP AT SCREEN.
IF screen-name = 'DAT-HIGH'.
screen-input = 0.
MODIFY SCREEN.
ENDIF.
ENDLOOP.
LOOP AT dat.
dat-high = sy-datum.
MODIFY dat.
ENDLOOP.

START-OF-SELECTION.

Re: Dynamic Date with Range- Changing only High value

matt — Tue, 12 Sep 2017 06:46:02 GMT

It's not clear, but I think he's wanting to set it in the variant, not in the code.

Re: Dynamic Date with Range- Changing only High value

former_member337802 — Tue, 12 Sep 2017 06:48:40 GMT

Hi,

Thanks for the answer, sorry to say that this is not suitable for my requirement as I want to achieve the requirement using the dynamic variant concept only. The report needs to be scheduled with the variant as batch job. I don't want to code the logic inside the program.

Thanks & Regards,

Aswath.

Re: Dynamic Date with Range- Changing only High value

Sandra_Rossi — Tue, 12 Sep 2017 11:56:43 GMT

The choices for variables within program variants are very limited. There's no option for what you want to do, so you have to find workarounds (for instance, define a variable in TVARVC, assign it to the date field in your variant, and update this variable daily using a custom program ; or, if the low date needs to always be 24.06.2011, you may hardcode it in the (custom?) program, and use "lower or equal to the current date" by using date variables, etc.)

Re: Dynamic Date with Range- Changing only High value

former_member337802 — Wed, 13 Sep 2017 04:29:34 GMT

Hi Rossi,

Yes that option is always there, anything not possible we need to achieve through code only. I was just wondering why SAP has not provided such options though they have provided the concept of dynamic date calculations.

I guess I have no choice but to use coding to calculate the dates dynamically when the program is being executed in background.

Thanks & Regards,

Aswath.

Re: Dynamic Date with Range- Changing only High value

former_member337802 — Tue, 10 Apr 2018 11:29:35 GMT

closing this thread as There is no option provided by SAP, I understood that this is not possible