Displaying the date in a different way

[djmalaka]

Hi all,
Is it possible to display the date as 29th September 2019 (or 29 Sep 2019) instead of 09/29/2019?

Thanks

[Aleksi]

Have you tried to set the “long format” to TRUE? You can find that option under column’s definition.

[djmalaka]

Thanks Aleksi. I wrote a CONCATENATE expression to get it sorted, now it’s fine. Thanks!