...use this virtual tag instead. I think it should work. Got the idea from @Hiccup's solution here…
I'm not even sure why that works.
Haha, it's using invisible magic.
Well, more 'invisible' than 'magic'.
It prepends an amount of zero-width spaces to the digits. The higher the number, the more zero-width spaces.
If you would imagine using zero's instead of them, it does something like::
1 becomes 001
2 becomes 0002
3 becomes 00003
Then, if you sort that ascending, you get:
00003
0002
001
instead of
1
2
3
But since zero-width spaces are invisible, you won't notice what is happening.
For some weird reason it reads "2021" as "0202" on mine…
There was a logical mistake in the formula I posted earlier.
This one should fix that:
$Replace($Replace($Replace($Replace($Replace($Replace($Replace($Replace($Replace($Replace($Date($Split(<Date Added>," ",1),dd/MMM/yy),9,9),8,8),7,7),6,6),5,5),4,4),3,3),2,2),1,1),0,0)
edit:
I now see the formula posted earlier in this thread was not a carbon copy of the one that I posted earlier elsewhere, but it's a new one created specifically for this purpose by Mayibongwe, only using a part of mine.
edit II:
I now also see doobydiper solved that issue himself already.
Can somebody suggest a good course for learning how to read please?