Skip to Content
Former Member
Apr 12, 2005 at 06:37 AM

Tricky Query - Ideas asked for.


Hello there!

I've a cube with data something like this:

<u>Char</u> | <u>Date</u>

123 | Jan. 1

123 | Jan. 10

123 | Jan. 20

Now, in the query i've valid-from and -to input varaibles to fetch the right data. In case i fill Jan. 12-18, it won't show up any records which is correct behavior. My requirement is i should check if the user input valid-fr and -to overlaps with min and max date for a char, it should come up.

Any ideas how to achieve this?

Many thanks in anticipation.