Question

Last two records in a column

Forum|Forum|9 years ago
May 31, 2017
4 replies
58 views

fariyafarhad

Hello all!

This seems like it should be a very simple thing to do but I am drawing a blank. I have an attribute column full of numbers (Dates). I just need to sort it and get the latest two records and put them under separate attributes. This is what the column looks like (already sorted descending).

I need to assign "170503" to one attribute (let's call it "DATE")

I need to assign "170331" to "previous_DATE"

Any help will be appreciated. Thanks!

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.