Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
sorting
1 view
Skip to first unread message
Frank
Nov 13, 2009, 7:12:32 AM11/13/09
to
Imported data base from appleworks via text file. First field is date
field. In Appleworks an example is 9/5/09. When I try to sort
FileMaker only apparently uses only the digit to the left of the slash
which gives unsatisfactory results. How can I fix this. This
unsatisfactory result is saved. What can I do to fix this?
Apparently FM needs format as 09/05/09.
field. In Appleworks an example is 9/5/09. When I try to sort
FileMaker only apparently uses only the digit to the left of the slash
which gives unsatisfactory results. How can I fix this. This
unsatisfactory result is saved. What can I do to fix this?
Apparently FM needs format as 09/05/09.
jahn
Nov 13, 2009, 11:33:58 AM11/13/09
to
Hi, Frank -
Make sure the field type is set to "date" in the File > Manage >
Database dialog. Then FileMaker will read the data is a date and sort
accordingly.
-Jahn
Ursus
Nov 13, 2009, 2:39:30 PM11/13/09
to
Adding to this,
If there already is a date this has to be in your local date-format. So if
your country doesn't use / as separator sorting will still not go right. If
which case you have to write a calcualtion which parses out old (wrong)
dates into correct dates.
--
Keep well / Hou je goed
Ursus
"jahn" <jahnbi...@yahoo.com> schreef in bericht
news:9b64a58b-7637-42e8...@x25g2000prf.googlegroups.com...
0 new messages