fileNameFormat ( _path ; _fileName ; _date ; _fileExt ; _theDatePosition )
Return the full path, including file name with a formatted date.
Be the first to rate this function Log in to vote
Josh Ormond - Show more from this author
fileNameFormat ( "" ; "SalesReport" ; "" ; "pdf" ; "" )
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Return the full path, including file name with a formatted date. The _path, _date, and _datePosition all have built in defaults.
There is also a helper function that only requires the _fileName and _fileExt parameters, and sets the defaults for you. Function name is fileFormatDefault
May 6, 2019
Is there a reason the file extension filters out "n" & "m" ?
I think it would fail for ".mov"
You could replace with "qwertyuiopasdfghjklzxcvbnm1234567890"
Josh Ormond, Iozax, LLC
May 6, 2019
|Thank you for pinging me Jonathan. I did correct that in our production files. I have updated the code to include the missing letters, and convert the file extension to lowercase. That will prevent problems if someone enters any uppercase case characters.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.