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, Inc.
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.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.