Formatting dates

Juraj Trenkler <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Again about dates. I am now at another computer and do not have original mails 
from Frank about these issues so I reply with new subject.

OOo1.9.121 Slovak version from Pavel Janik, mandriva 2006.1.

I created new database file. Table1 with three fields - first, second and 
third, all type Date.

1. I created new form Table1 by wizard with left layout. 

2. Changed field "first" to formatted field and changed format to DD,MM,YY. 
Works.

3. Formats DD MM YY or DD/MM/YY worked too. 
Format DDMMYY which I used with FoxPro did not work, (I got wrong dates after 
typing) but I can live without it.  

4. When I changed field "second" to formatted field too and changed format to 
the one I defined for field "first" then field "second" stays empty and I 
cannot put data into it.

5. When I format field "first" to some default date format (always as 
formatted field) I can use my format with field "second"

So it looks that I can use user defined format only for one date field in the 
form. 

juraj
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.