The function you got is pretty good and efficient. I don't see any way to make it better.
The pain seems to lie in the repetition of using the same function over many other parameters and variables.
I had similar pain in other cases. Here are ways to ease the pain.
You may use the same technique from above articles by using Excel or Tableau to automate the creation of formula instead of doing it manually.
Thanks for the answer. I guess there is really no escaping it. I will read the articles. Thanks!
I have also tried: STR(Dateparse("dd.MMMM.yyyy", STR([Yesterday]))) But then I just get a blank value. (I need the result to be in the string format because I am concatenating it with another string.
Thanks for the answer. I guess there is really no escaping it.
DATEPARSE returns NULL (blank) when computer language is set to other language than language of the month names. Some workarounds are documented in DATEPARSE foreign month names.
I mention this for educational purposes (for you and random readers) knowing that this question got a correct answer more than a year ago and therefore closed. Therefore no need to respond to this comment.