Picking up valid records on query key date
I need to pick up the records valid on query key date. The ODS has 'Valid from' and 'Valid to' Dates. I need to Pick up records for which query key date falls in the Valid from and to range.
Any idea how to achieve it.
i think its Simple one but I am not able to fix it somehow.