Skip to Content
0
Former Member
Nov 14, 2012 at 10:42 PM

how to select thelatest date and data !

29 Views

Hi

I have a particular set of work orders and different dates in whcih the work orders were generated and their corresponding summary.

For eg:

WO Date Summary

123 9/11/12 abc

123 9/12/12 bcd

123 9/13/12 efg

1234 9/1/12 xyz

1234 9/2/12 asd

I want the output to look like (select the sumary for the latest date of each work order)

WO Date Summary

123 9/13/12 efg

1234 9/2/12 asd

I was able to create a variable for date to chose the latest date

date1 = max(date) in ([WO])

but after that when i pull the summar along with it I am getting max of date fields but all summary,

how would you suggest doing it? Do I need to create another variable for summary? If yes how would you create a variable for summary?

I am using BOXI 3.1 SP3 FP3

Cheers!