the glass is 2025-02-01 full

You can wind up in the same trap in VB/VBA as well. It baffles me that in this current century there are still languages where text concatenation symbols and mathematical operators are the same character.

It's even worse in the case of VB because you can also use & explicitly to concatenate strings, whereas + can be either a mathematical operator or a string concatenator depending on context and the types of variables you've put it between, which VB may or may not decide to cast into strings depending on an arcane set of conditions that nobody understands or remembers. So the solution was right there all along, i.e. just make & the only concatenator and reserve + for math only. But that would be too much like right.

Depends on your date format. For it to be a problem to begin with, you need to use a date format with "/" as the separator. If it's 1st of Jan or Feb 1st then depends on the order.

And of course you need to enter an actual fraction, instead of like 0.5. This also narrows down the locations where this is an issue considerably. I think it's mostly north America where fractions are more commonly used instead of decimals die to the imperial system, but there might be other places where it's common, too, and I just don't know about it.