Hi
I have records like this for a particular '0Material'.
0MATERIAL STATUS UDATE
M1 I0068 2/11/2007
M1 I0070 10/11/2007
M1 I0072 22/11/2007
My Client enters the 'UDATE' value in the selection screen. And My Client wants latest records with corresponding 'UDATE'.
1)Suppose my client enter the 'UDATE' as 1/11/2007 - 15/11/2007 then he need to gets
M1 I0070 10/11/2007
2)Suppose my client enter the 'UDATE' as 1/11/2007 - 30/11/2007 then he need to gets
M1 I0072 22/11/2007
3)Suppose my client enter the 'UDATE' as 1/11/2007 - 3/11/2007 then he need to gets
M1 I0068 2/11/2007
So how can do like this for the user. please tell me im unable to solve this problem since three days.
Regards
kumar