Can I select the last 10 records by a datetime field

Gerri shared this question 3 years 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.

Comments (4)

photo
1

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

photo
1

Hi Gerri,


Any luck in getting this to work?


Regards,

Nathan

photo
1

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

photo
1

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