I'm not the best on understanding text mode, but in my limited understanding, I feel that the problem is in your order of operations. Your valueexpression is going to run first and then the valueformat is going to run after this.
For example, if the date is 3/1/25, your valueexpression will turn t...