OK, this is getting more frustrating. Not having had any replies, I’ve been looking at alternate ways to do this. I’ve discovered that if you create a text item on a page and connect it to a Date/Time field in a dataset, it comes up with a whole variety of date formats - some with the time and some without - to choose from. Ditto for a text box in a repeater.
So the function to create all sorts of date formats already exists within Wix! As far as I can see, the only place you CANNOT use it is in a column in a table which is linked to a Date/Time field. This is absurd! Does anyone from Wix read these posts, and is there an answer? Getting a bit frustrated here… I’ve found 2 other threads that were asking the same question, and neither of them were answered either…