Skip to Content
0
Former Member
Apr 23, 2009 at 03:58 PM

Maximum (latest) date to be displayed in the result of the query.

1431 Views

Hello,

I have an order which is having multiple dates but i want to have only the latest of them all .

Like this, whenever we have same orders with multiple dates, the maximum date only has to be displayed in the query.

For example,

Order Date (DD/MM/YYYY)

900001 01.02.2009

900001 02.02.2009

900002 03.02.2009

900002 04.02.2009

Finally, in the query the below orders should only be displayed.Why because, these are the max dates.

900001 02.02.2009

900002 04.02.2009

Please let me know solution for the above requirement.

Thanks

Ravi