selecting the maximum date
I Have packed dates as characteristic for each production order ,I want the latest packed date to be selected, into other column. Is there a way to do it in query Designer.
For Ex :
Prd.Order PackNo. packdate latest pakced date
1234 p123401 01.08.2008 02.08.2008
1234 p123402 02.08.2008
1234 p123403 02.08.2008
Here I have packdate ,I want the latest packed date from querydesigner.
Edited by: mandha on Oct 16, 2008 1:09 PM