Does anyone know a way to format a DateTime f...

Does anyone know a way to format a DateTime field to show on screen in the following format? I can’t see a way of specifyign custom formats without using concatenation by breaking up DateTime parts.

14 JAN 2019 3:15PM

1 3 391
3 REPLIES 3

I have this and it works but I was hoping for something a bit easier to read and maintain. i.e. something like DateFormat(“DD MMM YYY etc”)

CONCATENATE(RIGHT((“0” & DAY([Checkout])), 2)," “, INDEX(LIST(“JAN”, “FEB”, “MAR”, “APR”, “MAY”, “JUN”, “JUL”, “AUG”, “SEP”, “OCT”, “NOV”, “DEC”), MONTH([Checkout])), " “, Year([Checkout]), " “, SUBSTITUTE(RIGHT([Checkout],11),”:00”,”"))

There is no way to custom format dates and times short of “concatenation by breaking up DateTime parts”.

HCF
Participant V

You can make a Virtual Column and have a Formula = Text([DateField], “DDD MMM YYYY H:MM AM/PM”)

Top Labels in this Space