I have a table with a list of individual material purchases and the date of each purchase. Based on this, I would like to retrieve the next to last purchase of a material.
For example, material 123456 was purchased in 1/5/2016, 2/3/2017, and 5/8/2018. Based on the material number, I would like to get the next to last purchase which, in this case, would be Feb-17. It would be preferable to retrieve data in the format that I just indicated (i.e., Feb-17).
I have tried unsuccessfully to use max and large for an array. I would appreciate any help in this matter.
For example, material 123456 was purchased in 1/5/2016, 2/3/2017, and 5/8/2018. Based on the material number, I would like to get the next to last purchase which, in this case, would be Feb-17. It would be preferable to retrieve data in the format that I just indicated (i.e., Feb-17).
I have tried unsuccessfully to use max and large for an array. I would appreciate any help in this matter.