[Solved] Formatting date
[Solved] Formatting date
In database, if i want to change the format of the date to another format like 'dd-mmm-yy' then how is it possible?
Last edited by assa on Wed Jan 10, 2018 3:59 pm, edited 1 time in total.
OpenOffice 4.1.4 and Operating System Windows 8.1
Re: formatting date
If you already have a Form connected to the database, then you would go Form > Edit
Right click on the date field you want formatted and select the Control... menu.
From that, select the General tab, then scroll down to Date Format and select the elipses '..." button. Here you can modify the formatting of the date for the Form.
It's similar in the DDL.
Right click on the date field you want formatted and select the Control... menu.
From that, select the General tab, then scroll down to Date Format and select the elipses '..." button. Here you can modify the formatting of the date for the Form.
It's similar in the DDL.
LibreOffice 6.1.3.2 (Linux Fedora 29 on x86_64) with 'Notebookbar'
OpenOffice.org since 2002-12. LibreOffice user since 2013-current.
HSQLDB 2.5.0
OpenOffice.org since 2002-12. LibreOffice user since 2013-current.
HSQLDB 2.5.0
Re: Formatting date
If dd-mm-yyyy is not availlable for the date control, you can replace it with a formatted control. A formatted control works like a spreadsheet cell, including localized and user-defined number formats.
You can also open reports for editing and assign number formats to single elements.
P.S. Mail merge fields linked to a date field are formattable as well.
You can also open reports for editing and assign number formats to single elements.
P.S. Mail merge fields linked to a date field are formattable as well.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Formatting date
Thanks for the help! It was useful.
OpenOffice 4.1.4 and Operating System Windows 8.1