Can I select the last 10 records by a datetime field

Gerri shared this question ago

Answered

On a report I need to be able to select the last 10 records by a datetime field (e.g. 10 most recent bookings.)

How can I do this?

Thank you.

The same question

Replies (4)

Nathan Schroeder ●

Hi Gerri,

Thank you for getting in touch. I think that the best way to do this will be to create a pre-defined calculated field, using the "Days Between" function. You can set on value to "current day" and the other to your date field. This will return a numeric value representing how many days ago each row was.

You can then apply the "Bottom 10" Advanced Function to this numeric field to limit the results to the last 10 records.

73048c0aaeb60c649192ecb63721d548

Please let me know if this is not relevant to your use case or if you have any questions on implementing this.

Regards,

Nathan

Reply URL

Nathan Schroeder ●

Hi Gerri,

Any luck in getting this to work?

Regards,

Nathan

Reply URL

Nathan Schroeder ●

Hi Gerri,

I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!

Regards,

Nathan

Reply URL

Gerri ●

Thank you very much Nathan, appreciate the solution and your help.

Reply URL