Getting the most recent entry in alphanumeric field

[Evan0211]

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.

[David_Friend]

@Evan0211 can you follow this article from Toni?

https://community.qlik.com/t5/Official-Support-Articles/Sorting-Alphanumeric-Data/ta-p/1712855

[Evan0211]

Unfortunately, I don't have access to load RecNo in the data load.