Hi, I have been trying to build a small CRM app for our sales team. This CRM app would pick data from other 2 apps called ‘Contacts’ and ‘Deliveries’. (The contacts app will have details of the customers and Deliveries will have the list of deliveries made to this each customer). Now back to my issue, I this CRM database contains columns,
- Customer name
–> references from contact table 2. Related Deliveries --> List view of ‘Deliveries’ table for the respective customer.
Last delivery date --> Max delivery date of Related Deliveries.
Time since last delivery --> No of days since last delivery was made.
I have been struggling on how to achieve the 3rd (Last delivery date) and 4th (Time since last delivery). I browsed the articles on MAX functions on a reference list, but couldn’t get much. Can anyone help me on this?