Jump to content

How to sort by date, from a list imported fm Excel


This topic is 7211 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I have version 7. I've imported a list of names from an Excel table. The fields all get imported fine, first name, last name, address, etc. Each record contains a date field in the form of 03052005, 09102005, 07022005, etc. I've defined this field in Filemaker as a date field, but even after I do that, these entries do not change to the "9/25/2005" which is the form my creation and modification date are in. And I cannot seem to be able to sort the records by the date field. Any idea what I'm doing wrong?

[email protected]

Link to comment
Share on other sites

If your imported date field is defined as either a number or text field, it should sort in the proper order. The internal number format for a date in FileMaker is the number of days starting on 1/1/0001. Your imported format will not convert to a correct date when imported to a date field. If you import to a text field, the following calculation will give you a date.

Date (calculation, date) = Date( Left(YourField, 2), Middle(YourField, 3,2), Middle(YourField, 5, 4))

-bd

Link to comment
Share on other sites

This topic is 7211 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.