> Why can't I have it sorted chronologically?
FileMaker Inc. cannot possibly spare the engineers required to implement this feature. You could use a format of "20120816" which is self-sorting.
I’m with Steve, WHAT COULD BE EASIER than, DO NOT SORT THIS LIST.
Seems to me to be a missing feature, “here is my value list, oh by the way don’t sort it for me.”
But realize that if it does not sort it, it probably won’t /can’t filter out duplicate values.
The sword does indeed have two edges.
Why can't I have it sorted chronologically?
Text is text; numbers is numbers; dates is dates. Each has its own sorting rules. If you want to sort a list of dates which are entered as text, you would need to convert the text to date, which could be achieved in a calculation, and then base your value list on that.
1 of 1 people found this helpful
Instead of creating the list, populate a separate table, one field, type date and then use that to create your value list, the resulting value list will be in date order as will the global checkbox. The question is how difficult will it be to create the records on the fly.
Agnes Barouh has a wonderful custom function that will sort your ListOfDates, but the result can't be used in a value list as it is not indexable.
Your reply (and a good night's sleep) prompted me to re-think my strategy and I have made it work. Thanks!
My ListOfDates field was being generated from related records in another table using the List() function. The relationship matched every Monday in the related table or every Tuesday, etc depending on which weekday the user selected. So my value list is now a conditional value list using the same relationship, and the dates are properly sorted! I don't need no stinkin' ListOfDates text field.
By the way, I was using Agnes' wonderful custom function as an auto-enter calc so it could be indexed.