Skip to Content
0
Former Member
Dec 25, 2007 at 07:26 AM

Urgent help(getting lastest date records in the report)

20 Views

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