How to add text to FormatDateTime

Graham Walker

Solved

Question

i wanted to add text to my format date time expression so it displays e.g. 24 Jun 2022 at 11:55

is this possible?

FormatDateTime(xxxxxxxxx, "d MMM yyyy HH:mm")))

thanks

24 Jun 2022

Dorine Boudry

MVP

Solution

Hi Graham,

Just like you add spaces or "-" or ":", you should be able to add any other text you like.

You might have to add some escape characters in front of letters that also have special meaning. I think it´s a "\".

Did you try and not succeed ? I´m not near a computer now, so I can´t try it out myself.

Dorine

24 Jun 2022

Graham Walker

that worked, thanks!

i had to use two escape characters

"d MMM yyyy a\t\ HH:mm")))

24 Jun 2022

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.