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
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”.
You can make a Virtual Column and have a Formula = Text([DateField], “DDD MMM YYYY H:MM AM/PM”)
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |