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

--
For unsubscribe instructions e-mail to: [email protected]
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

Reply via email to