Brian Dunning's FileMaker Custom Functions

DateToSortableText ( thedate )

Returns a sortable textual representation of a date value

  Average rating: 4.3 (33 votes) Log in to vote

Theo Ros   Theo Ros
*
http://notapplicable.com

Share on Facebook Share on Twitter

  Sample input:
DateToSortableText ( Get ( CurrentDate ) )
  Sample output:
20050530 (if today is May 30, 2005)

  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

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.