Will not sort by date in table layout, but does change the order

[somasf415]

I am trying to run a list report and have it as layout and created a script for it. It is all based on info from my "clients" table. 

When setting it up i put to sort by sale date however it does not sort. It is a random order. When i am in the layout i try the sort tool by that particular date field and change from descending to ascending order it moves them around but in no particular oder. I can't even make sense of what it is trying to do.  I can sort by other fields.  Any ideas of what might be wrong with the field.  The field is an automatic field that puts the date in when the record is created and shows the date as 17, November 2012

 

 

[Lee Smith]

Does it really have a comma in it? The field type sounds like it might be text instead of Date?

[somasf415]

Yes it had a comma, I now checked to make sure it is a date field and it is and it is created automatically by filemaker.  I only chose the format as an option in the inspector. I changed it to a different format to see if that was the problem but it is not because i have the same issues. It is really strange.   I printed a pdf of the layout to show here but i don't see anywhere where I can attach a file in this layout. Only access old attachments in my media which also won't let me add a new one.

[Lee Smith]

Rather than attaching a PDF, why not Attach a Copy of your file instead.

 

The process is rather easy, just follow these steps.

Step 1
Find the file on your hard drive, and zip it.

Step 2
Do not use the Quick Reply, BUT instead, choose the More Reply Option 

Step 3

Click on Attached Files and this will take you to your hard drive to locate your file that you want to attach and that you previously zipped. Select the file, and then click Attach This File, and then click Add Reply.

If you should have a problem let us know.