Dear All ,
I Have three fields in data base table .
SEQNO - Sequence Number
FDATE - From date
TDATE - to date
now suppose i have one record like
001 13.12.2006 27.12.2006.
In my Program I have given selection screen with parameters for FDATE and TDATE .
user may enter FDATE = 13.12.2006 .
TDATE = 13.12.2006 .
or He may Enter FDATE = 12.12.2006 .
TDATE = 14.12.2006 .
or He may enter FDATE = 17.12.2006 .
TDATE = 18.12.2006 .
for all above cases of selection I need to fetch the record given above .
How should I write the database Query