DateToSortableText ( thedate )
Returns a sortable textual representation of a date value
Average rating: 4.3 (33 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Returns a sortable textual representation of a date value.
To text-sort dates, you will have to place the biggest unit (year) first,
followed by the month an day.
This will result in textvalues that will sort correctly, for instance
in a portal-sort solution.
Syntax: DateToSortableText ( thedate )
Return type: Text
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.