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

On 01/19/2013 11:59 AM, Ian Whitfield wrote:
Hi All

I now have my Main Form with Sub Form working well with one remaining problem...

My Sub Form has a Field 'Date' (Type Date) and I have set it to sort into Date Order by selecting the field 'Date' and the value 'Ascending'. My date format is DD/MM/YY (all numbers). But it seems to sort ONLY on the DD value and not on the whole date.
Here is an example -

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  *

The three stared lines should be at the top of the list!!

Any idea how to fix this please?

My set-up is PCLinuxOS 2012; MySQL 5.1.55; LO Base (as front-end)

Thanks a lot

Pretoria RSA

Some observations: the sorting is first done by "DD" and then by "MM". You do not have the proper data to determine if they are then sorted by "YY". I think it is possible that it is. A simple test would be to add a record with the date 07/01/12. If I am right, this record will appear just above the date 07/01/13. It is possible that the date format MySQL is using is YY/MM/DD. You could change your date format to MM/DD/YYYY to see if the dates then matches this format such as 24/10/12 becomes 24/10/2012. If it does not change, this is likely where the problem lies. Second possibility: what you think is a date format is really a text format.


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.