Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

sorting

  
   Database Forums (Home) -> FileMaker RSS
Next:  Validation Duplicate  
Author Message
Frank

External


Since: Nov 13, 2009
Posts: 1



(Msg. 1) Posted: Fri Nov 13, 2009 4:12 am
Post subject: sorting
Archived from groups: comp>databases>filemaker (more info?)
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.

 >> Stay informed about: sorting 
Back to top
Login to vote
jahn

External


Since: May 24, 2008
Posts: 13



(Msg. 2) Posted: Fri Nov 13, 2009 8:33 am
Post subject: Re: sorting [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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

 >> Stay informed about: sorting 
Back to top
Login to vote
Ursus

External


Since: Feb 13, 2009
Posts: 5



(Msg. 3) Posted: Fri Nov 13, 2009 3:25 pm
Post subject: Re: sorting [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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" schreef in bericht

> 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
 >> Stay informed about: sorting 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Portal sorting in FM7 - I have a FM7 database with a table for "Ads" -- Advertisements and a related table "insertions" which gives me the specific dates of the magazine issues that a particular ad appears in. The "insertion" field is a select list...

Sorting a Summary... - Table1 - list of prescribing doctors Table 2 - List of prescriptions written What I did was add a sub-summary part by Doctor ID This gives me the total amount of prescriptions they wrote in the given month (found set example from the 1st to the 31st o...

GTRR and sorting - WinXp FMP9a I have 2 table_A and table_B and 2 layout_A, layout_B. I make a search in layout_B, then sort with field_X, a script Goto Related record gives all correct records in layout_A but without sorting ! Is it normal ? If yes, it there a solution....

Help Portal Sorting Relationship - I have a portal that is showing SELF::SELF related records. I want to create a simple sort off of a calculation that shows the status of the record as "Active" or "Complete". For some reason the relationship isn't working. Can you ...

Sorting for sub-summary report - I have a report with 3 sub-summaries, with "Yes/No" fields set by the user to determine whether the sub-summaries are required or not. The user can select any combination of the 3. I'm now trying to write the script to produce the report, and...
   Database Forums (Home) -> FileMaker All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]