Formula to find the last known order date for a customer ID
We have a table where we are trying to add up the customers total order value over a period of time and would like one column to note the last known order date for the customer. How would I write the statement to find that value?