John Gregson wrote:
I am using Open Office 3.1.0 (build 9399)
Java version is: 1.6.0_15
I am using a PC with Vista 32
<snip>
Cannot change date format and have it 'stick'; also cannot find a
suitable date format.
<snip>
When I start the process to change the Date format, I open the Table
in Edit mode.
1. Select Date field, bottom pane shows:
Entry Required - No
Default Value - blank
Format Example - 01/01/00 (has faint grey characters)
2. Click on button to right of 'Format Example'; This brings up the
"Field Format" window.
3. Under Category select DATE in FORMAT pane.
Select: 31. Dec. 1999. At the bottom of this window the
format code is: D. MMM. YYYY.
(note Language selection is: English (USA)
Click OK at the bottom.
4. Back to bottom Pane (#1 above.)
Format example is: 1. Jan. 1900 (faint grey characters).
5. Top Menu Bar- File/Close/ Save changes-yes
6. Reload oo and Base; open Table in non-edit mode. Entered date in
desired format: 10. Aug. 2009.
7. Opened Form, but date field has a format of DD/MM/YY.
Yes it does -
Do this for me please.
Open your Base file.
Switch to the Tables section.
Open your table's dataview window. (For example: double click the table
you want to work with)
Now - right click the mouse in the header area of the date field.
From the context menu select "Format Column"
Select your format.
Notice that the "save" tool button on the ODB windows toolbar is now
active. This is because you have changed the date format for the table's
data view window.
The data view change should now 'stick'.
If you create your own forms you find that you need to set the format
for the actual form control that will display/edit the date value.
Also I'd pass along this. If needing dates for display only purposes -
say for reports (screen or document) - the TO_CHAR function changes the
date to a string in the SELECT statement and handles the formatting: (see)
http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#Date_and_Time_Functions
Of course that doesn't help you with data input but for reporting
HTH
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
