Hello @Amy_Spalletta ,
I use this one all the time - it is pretty compact and does the trick. Replace today() with any other date reference as you see fit.
split(formatdatetime(Today(),7,4),",").first()
This formula is for European date settings (parameter ‘7’) and 24 hr time notation (parameter ‘4’). In the output the time is not shown, because we only use the first() part of the splitted output.
This formula and it variants could be your base for many different notations.
If you store the parameters in a named field (canvas formula) on an (hidden) parameter page, you can change the appearance of all the dates in a document by changing only the one parameter. Let me know if you don’t understand what I am trying to say here and I will make a sample doc for you (next week at the earliest though).
Greetings,
Joost
PS: the posting you are referring to is a year old - the formula used back then was pretty elaborate (with regexreplace), but new insights let to this pretty straightforward solution (with the help of various inputs in another thread in this community)