Skip to Content
0
Former Member
Apr 14, 2014 at 02:03 PM

how to get most recent data

37 Views

I have a situation where I am to show the 'most recent ' customers in a data set. Most recent means the latest invoice date.

but the data is being processed grouped by invoice number.

if i try to sort by date descending, it doesn't let the date be more in higher position than the Invoice nbumber.

this seems simple enough but how do i make the selection display to be by most current date.