05-20-2010 8:29 AM
Hi..I have taken 3 local variables date1 date2 and date3 .How to populate them in table (likp-lfdat).In date1 i have dates of lfdat between 14/05 to 21/05 and date2 from 22/05 to 28/05 and date3 one more week.In o/p how can see data between these dates range only?
05-20-2010 8:36 AM
Use Where clause as:
WHERE
LFDAT IN DATE1
OR LFDAT IN DATE2
OR LFDAT IN DATE3.
Regards,
Anil