Returns the date a file was accessed (opened) for the last time.
TrFile_GetDateLastAccessed ( 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 date the file was last accessed. 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|
Other errors may be returned.
Troi File Plug-in 3.5
FileMaker Pro 16 to 19
You can use FileMaker styled paths, like “filewin:/C:/MyFiles/test.txt”.
Set Field [ lastAccessedDate ; TrFile_GetDateLastAccessed ( "-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:
lastAccessedDate 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 [ lastAccessedDate ; TrFile_GetDateLastAccessed ( "-Unused" ; gFilePath ) ]
This will store the date the file, specified by gFilePath, was opened for the last time in the field lastAccessedDate.
Used in example file