Hello,
I also faced this problem, and agreed with other company operators the best and reliable way to use this was to simply put DATE as an number.
We use such format 20210631, which allow to simply sort it without any problems since few years.
Best Regards
Seweryn