Returns the creation date for the file specified by the filePath.
TrFile_GetDateCreated ( switches ; filePath )
|switches||not used, reserved for future use. Leave blank or put "-Unused"|
|filePath||the path to the file for which you want the information|
Data type returned
The returned result is the creation date of the file. The date is in the same format as a date field.
An error code might also be returned. An error always starts with 2 dollars, followed by the error code. Returned error codes can be:
|$$-43||fnfErr||File not found, check if the path is valid|
|$$-1||genericErr||The file could not be found (older versions of the plug-in)|
Other errors may be returned.
Troi File Plug-in 1.0
FileMaker Pro 16 to FileMaker Pro 2023
You can use FileMaker styled paths, like “filewin:/C:/MyFiles/test.txt”.
Set Field [ creationDate ; TrFile_GetDateCreated ( "-Unused" ; "C:\Test.txt" ) ]
This may return the number 730172 which is equivalent to the date: 22 Feb. 2000.
We assume that in your FileMaker file the following fields are defined:
creationDate date gFilePath Global, text
gFilePath should contain the path to the file, for example “D:\Logs\L2000_01.TXT” (Windows) or “Mac HD:Logs:Log 2000_01” (Mac). In a script add the following script step:
Set Field [ creationDate ; TrFile_GetDateCreated ( "-Unused" ; gFilePath ) ]
This will store the creation date of the file specified by gFilePath in the field creationDate.
Used in example file