Re: [users] Week number in OpenOffice.org Base

2006-08-02 Thread Dmitri Pissarenko
Hello! Thanks all for the help! Best regards Dmitri Pissarenko - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Week number in OpenOffice.org Base

2006-08-01 Thread Cor Nouws
G. Roderick Singleton wrote: usually LOCALE settings. Find a Locale that matches your needs. There is a change coming up in OOo, in which the start day of the week is part of the Locale, taken from the international standard. Greetings, Cor -- Cor Nouws http://why.openoffice.org/

Re: [users] Week number in OpenOffice.org Base

2006-08-01 Thread Barrie Backhurst
On Tue, 2006-08-01 at 14:59 -0400, John Hostage wrote: > In fact, starting the week on Sunday seems to be a convention only in > the US. The international standard is to start on Monday > > I'm not familiar with what OOo does, but it seems to me it sh

Re: [users] Week number in OpenOffice.org Base

2006-08-01 Thread John Hostage
In fact, starting the week on Sunday seems to be a convention only in the US. The international standard is to start on Monday I'm not familiar with what OOo does, but it seems to me it should follow the standard. Week numbers aren't even used in th

Re: [users] Week number in OpenOffice.org Base

2006-08-01 Thread Manfred Moser
Not correct. That is internationally different and there should be a setting for your database whichever you use. manfred Joe Conner wrote: Weeks DO begin on Sunday. Check your calendar. Dmitri Pissarenko wrote: Hello! I have a table with several fields, one of them is a date field. I wan

Re: [users] Week number in OpenOffice.org Base

2006-08-01 Thread Joe Conner
Weeks DO begin on Sunday.  Check your calendar. Dmitri Pissarenko wrote: Hello! I have a table with several fields, one of them is a date field. I want to create a query, which would tell me the week number for every date. For this purpose I use the following query: SELECT WE

[users] Week number in OpenOffice.org Base

2006-08-01 Thread Dmitri Pissarenko
Hello! I have a table with several fields, one of them is a date field. I want to create a query, which would tell me the week number for every date. For this purpose I use the following query: SELECT WEEK(date) AS "Week", date FROM myTable This works, however the week number calculation ass