Get max date from array

Get max date from array

SarbastSarbast Posts: 85Questions: 0Answers: 0

Hi,

I have two joined tables as follow:
Table 1: Customer
Table 2: Orders

I would like to get just the latest date of the order not all dates. Moreover, if a customer has three orders I want to get a customer details with the latest order's date.

Example:

customer 1 ---> 01/05/2021
customer 1 ---> 10/05/2021
customer 1 ---> 20/05/2021

Get just
customer 1 ---> 20/05/2021

Thanks

Replies

This discussion has been closed.