Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

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.


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.