Ask Your Question

base list box date format

asked 2020-02-26 17:36:34 +0200

Dazzer gravatar image

LO, Split hsqldb, Mac OS Catalina 10.15.3


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 ?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-02-27 03:05:03 +0200

Ratslinger gravatar image


With SQL you can change format with:

to_char("YOUR_FIELD", 'DD/MM/YY')
edit flag offensive delete link more


Perfect, thank you

Dazzer gravatar imageDazzer ( 2020-02-27 15:38:25 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-26 17:36:34 +0200

Seen: 26 times

Last updated: Feb 27