Jump to content

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

Recommended Posts

ok.. when i do a search i want the records to sort by 3 fields, first the year, then the month, and then the day..

makes sense.. seems easy enough.. but here is the catch.. i am writing out the months not using numbers to represent them.. i want the to show up in chronilogical order not alphabetical.. can this be done.. i know i can do it in file maker by telling it to sort according to the order of a value list.. but is there a way to do this in CDML or will i have to go back and have the months represented by numbers?

Link to comment
Share on other sites

Nope.

Create a custom value list and type the month names int he order they should be -- January.. December. Go back into the sort dialog, click on the month field and select the option to sort by custom order based on value list, and choose the list from the menu.

Done.

Well, you could do it with a calculation field if you want (use the Month[date] function). But this method illustrates the method of getting records to sort in a user-defined order, which is an issue that pops up occasionally -- and not just with months.

[This message has been edited by Vaughan (edited December 20, 2000).]

Link to comment
Share on other sites

i was able to figure out a way to do it on my own.. i knew how i could sort them in file maker.. i needed a way to be able to sort them buy the date when using web companion to view the database in a web browser and using the search function.. i couldn't simply tell it to sort by the field because it would put them in alphabetical order.. not chronilogical.. i didn't think you could sort by a user defined value list when viewing in a web browser...

anyway.. i found a way to do it.. i use a calculation field to change the months into numbers. (using the CASE calculation) then i sort the records by this field.. it works just like i need it too.

thanks for the help anyway,

B-man

[This message has been edited by bman (edited December 20, 2000).]

Link to comment
Share on other sites

This topic is 8611 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.