Gurus,
I have a valid to and valid from dates in ODS. The user is allowed to enter a date on the selection screen. If the user entered date lies in between Valid from and Valid to dates only these records need to be displayed in the report.
E.g.
ODS:
Valid From Valid to Functional Area
01/01/2009 01/01/2099 X
01/01/2010 01/01/2011 Y
01/01/2011 01/01/2012 Z
User Entered Date: 01/02/2010
Report Output:
X
Y
How do i do this? Appreciate your immedite assistance.
Thanks,
Ravi Ananthuni