Skip to Content
0
Former Member
Jun 03, 2013 at 04:21 PM

Min and Max Dates

23 Views

Hi,

I am trying to get the maximum date of "Date Forward to Staff" for each "Work Order ". For example, there are two work orders with the number 345 787 that are each associated with a "Date Forward to Staff". I only want ONE work order number to appear in the table and I want it to be the one that has the maximum "Date Forward to Staff". In this case, for work order # 345 787 i would want to keep the one where the date is 26/03/13. All my attempts resulted in absolutely no change in the table. Here is what I tried:

- Max([Date Forward to Staff]where(WorkOrderDetails Description] = "Forwarded To Staff GIT_SHIPPING")foreach([Work Order#]))

Thank you very much,

Geneviève Nantel

Attachments

maxWorkOrder.png (24.7 kB)