I have a database that I wish to sort in chronological order. I have included a date and time field. Date is primary sort and time in secondary. When I add a new record on the phone the new record will not sort properly. It appears that a date entered on the phone has a slightly different value than one entered from the desktop. The problem is resolved by synchronizing the db to the windows desktop.
Tom Mihalcik