Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Resolve Range Table Content

Former Member
0 Kudos
152

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

3 REPLIES 3

Former Member
0 Kudos
45

Hi

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.

Sandra_Rossi
Active Contributor
0 Kudos
45

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

former_member226519
Active Contributor
0 Kudos
45

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