Skip to Content
0
Mar 24, 2010 at 03:13 PM

Getting records based on date entered by the user

61 Views

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