Min and Max Dates

[Former Member]

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

[former_member189638 · Accepted solution]

I think that is happening because you are using the ForEach function inside the Max parenthesis. try using it outside as shown below.

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

[Former Member · Accepted solution]

Thank you Rakesh