topic Re: Resolve Range Table Content in Application Development and Automation Discussions

Resolve Range Table Content

Former Member — Thu, 20 Oct 2016 20:25:17 GMT

Hello all,

I would like to resolve the content of range table.

The range table will be taken over from the SELECTION-SCREEN by Date from-to. The user can enter DATE from, date to, with exclusions, greater than, etc.

Now I need a function to resolve the entered ranges, that a serial date range is resulted; for example:

SIGN   = I
OPTION = BT
LOW    = 10.01.2016
HIGH   = 12.01.2016

The result is: 10.01.2016, 11.01.2016, 12.01.2016.

However, all combinations are possible, so that the result could be more complex.

Is there any function to handle this problem?

Thank you very much & best regards,

Kurt

Re: Resolve Range Table Content

Former Member — Thu, 20 Oct 2016 21:06:14 GMT

So you need to get all dates meet your range?

I don't believe there's a function and it's not easy to create an algorithm, because you can have an infinte result if the range is not filled under particular conditions.

Re: Resolve Range Table Content

Sandra_Rossi — Fri, 21 Oct 2016 07:27:58 GMT

could you tell the real scenario where you need this? Usually, we only need it while using SELECT ... WHERE datum IN date_range...

Re: Resolve Range Table Content

former_member226519 — Wed, 02 Nov 2016 15:46:39 GMT

create a table with only one field DATE

fill it by report with all dates from 19000101 to 99991231

select all dates WHERE date IN range