‎2016 Oct 20 9:25 PM
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
‎2016 Oct 20 10:06 PM
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.
‎2016 Oct 21 8:27 AM
could you tell the real scenario where you need this? Usually, we only need it while using SELECT ... WHERE datum IN date_range...
‎2016 Nov 02 3:46 PM
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