Returning the second date (chronologically) of a connected record

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?

Hi there!

If you don’t find the answer you’re looking for here, please consider checking out our Knack Expert Network to help you find an experienced developer to help you build out this idea with your app.

Thank you for sharing your question!