Hi Everyone,
I am having a database (libreoffice 5.2 base) with a Date field. It is formatted as 31/12/2016.
I then have a query where I want the date to show but with a different format. I want only the two last digits of the year.
I other words I want it to show as such…
table: 31/12/2016 -----> query: 16
I there a way to achieve that?
Many thanks.