Most recent DateTime

[paulpeyton]

I am trying to determine and display the most recent DateTime for a series of calls over a specific timeframe. In other words, we may call a customer five times a day for a period of five days. I only want to display the most recent calling day and the last call time attempted. I currently display all the calls over each given day. I would love to see if someone can assist with this as it has been driving me bonkers. Thank you in advance!

 

[lbass]

If the day and time are found in one datetime field, then you have several options, but all assume that you first group on {table.customer}:

1) After grouping by {table.customer}, sort by {table.datetime} descending, and drag {table.datetime} into the group header, and then suppress the details section. Or,

2) Go to report->edit selection formula->GROUP and enter:

{table.datetime} = maximum({table.datetime},{table.customer})

This will return only the most recent record. Or,

3) Go to format->section->details->suppress->x+2 and enter:

{table.datetime} <> maximum({table.datetime},{table.customer})

If these are separate fields, then concatenate them by using a formula like:

datetime({table.date},{table.time})

...and then use one of the methods above.

-LB

 

[paulpeyton]

-LB
Thank you for your response! It worked perfectly! You just saved me hours!

Paul