[libreoffice-users] Re: Database sort problem

On 01/19/2013 05:59 PM, Ian Whitfield wrote:


Hi Ian,

> Message No             Date
> 149                        01/01/13
>  58                         02/01/13
> 150                        02/01/13
> 225                        02/01/13
> 261                        07/01/13
> 307                        18/01/13
> 148                        18/12/12  *
> 260                        18/12/12  *
> 318                        19/01/13
> 319                        19/01/13
> 306                        24/10/12  *

It doesn't matter how you set the format, valid dates in mysql take the
form of YYYY-MM-DD, so that is how you should enter them from Base,
otherwise you will get unexpected results because your data entry is
ambiguous, and mysql will interpret the date and the sorting mechanism
from the start of the string of characters making up the date.

If you enter the dates as YYYY-MM-DD, then the sort will operate correctly.


Alex




-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted