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+h...@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
