Base list box date format

[Dazzer]

LO 6.4.0.3, Split hsqldb, Mac OS Catalina 10.15.3

Hi

I’m wondering if there is a way to format the date contents of a LO base form list box

The tabl formats are DD/MM/YY but list box always shows MM/DD/YY

There is no option for format in control properties, is this something that could be set within the SELECT statement ?

[Ratslinger]

Hello,

With SQL you can change format with:

to_char("YOUR_FIELD", 'DD/MM/YY')

[Dazzer]

Perfect, thank you