Brian Dunning's FileMaker Custom Functions

YYYYMMDD ( theFileName,theDate )

Create an 8 digit date suitable for sorting in a list of files.

  Average rating: 3.9 (35 votes) Log in to vote

Jack Rodgers   Jack Rodgers
Jack Rodgers, Inc.

Share on Facebook Share on Twitter

  Sample input:
YYYYMMDD( KeyField,DateField )
  Sample output:
ABC 20060803

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Appending YYYYMMDD to a file name, such as a report, will enable the cronological sorting of the files in a folder. This will be especially useful in FMP 8 where you can save as PDF or Excel. The definition can also be copied and used in a script. The File extension is not included assuming Filemaker will add it.



Log in to post comments.


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

Under construction. Email me your wish list for improvements.