Re: [libreoffice-users] Database sort problem

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) 3.6.2.2
>
> Thanks a lot
>
> IanW
> 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.

--Dan

--
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