# Returning the second date (chronologically) of a connected record

**URL:** <https://forums.knack.com/t/returning-the-second-date-chronologically-of-a-connected-record/14815>\
**Category:** Get Answers\
**Created:** [September 6, 2023, 7:02pm UTC](https://forums.knack.com/t/returning-the-second-date-chronologically-of-a-connected-record/14815 "2023-09-06T19:02:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Send\_Joe](https://avatars.discourse-cdn.com/v4/letter/s/f4b2a3/32.png) [@Send\_Joe](https://forums.knack.com/u/Send_Joe)\
**Post date:** [September 6, 2023, 7:02pm UTC](https://forums.knack.com/t/returning-the-second-date-chronologically-of-a-connected-record/14815/1 "2023-09-06T19:02:57Z")

</div>

Two tables are connected, one is Accounts and the other is Orders. The connection is one-to-many, respectively. I can calculate an account’s date of first/last order using min/max with date equations but how can I return the date of an account’s second chronological order?

---

<div class="post-metadata">

**Author:** ![Les](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/les/32/4243_2.png) [@Les](https://forums.knack.com/u/Les)\
**Post date:** [September 7, 2023, 5:18pm UTC](https://forums.knack.com/t/returning-the-second-date-chronologically-of-a-connected-record/14815/2 "2023-09-07T17:18:22Z")

</div>

Hi there!

If you don’t find the answer you’re looking for here, please consider checking out our [Knack Expert Network](https://www.knack.com/experts/) to help you find an experienced developer to help you build out this idea with your app.

Thank you for sharing your question!