I have a dataset that has alphanumeric fields and dates attached to them. How do I get the most recent alphanumeric entry?
Example:
| H0034 |
1/1/2024 |
| H0035 |
1/1/2024 |
| H0036 |
2/26/2024 |
How do I only pull the 2/26/2024?
I should add, the dates will not always be in order. Example
| H0001 |
6/6/2023 |
| H0002 |
1/1/2023 |
For this table, I would want to return just the 1/1/2023.
The field name for the H00xx field is [item_mod].
I have tried this: =if(left([item_mod],1)='H', num(replace([item_mod],'H','')), 0) to get the values in numerical order and then using MAX, but that gave me incorrect results.
