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

Le 19/01/13 17:59, Ian Whitfield a écrit :

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  *

Give us the data that you have in the underlying database table, rather
than that which LO displays, as this may/may not be a bug in the form
control itself, or in some other part of the LO code, as Girvin mentions.

To do this, use the mysql command line interface from the console :

SELECT "Message No", "Date" from whatevermytableiscalled, ORDER BY "Date"

You didn't say, but if you are using the mysql function DATE_FORMAT to
format your dates in a particular way, then you will probably encounter
this :

That might account for the behaviour you are seeing.


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.