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

(Mark Lonergan) #1

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

(Mark Lonergan) #2

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”,”"))

(Steven Coile) #3

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