Skip to main content

TrFile_GetTimestampLastAccessed (function reference)

By June 1, 2024June 4th, 2024Online Help, Troi File Plug-in
Troi File Plug-in > Functions reference > TrFile_GetTimestampLastAccessed
Troi File Plug-in for FileMaker Pro

TrFile_GetTimestampLastAccessed

Returns the date and time a file was accessed (opened) for the last time.

SyntaxFunction badge

TrFile_GetTimestampLastAccessed ( switches ; filePath )

Parameters

switches not used, reserved for future use. Leave blank or put "-Unused"
filePath the path to the file for which you want the information

Returned Result

Data type returned

Timestamp

Result

The returned result is the date and time the file was last accessed. The result is formatted like this:
YYYY-MM-DD HH:MM:SS. Store the result in a timestamp 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.

Originated in

Troi File Plug-in 3.5

Compatibility

FileMaker Pro 17 to FileMaker Pro 21 (2024)

Considerations

On Windows some file systems (FAT) only store the actual date of the last access. The time in this case the time part will be 00:00:00.

Example

Set Field [ lastAccessedTimestamp ; TrFile_GetTimestampLastAccessed ( "-Unused" ;  "C:\Test.txt" ) ]

This may return the result: “2006-12-22 15:55:17”.

Example 2

We assume that in your FileMaker file the following fields are defined:

   lastAccessedDateTime	timestamp
   gFilePath		Global, text

gFilePath should contain the path to the file for example “D:\Logs\L01.TXT” (Windows) or “Mac HD:Logs:Log 1” (Mac). In a script add the following script step:

Set Field [ lastAccessedDateTime ; TrFile_GetTimestampLastAccessed ( "-Unused" ;  gFilePath ) ]

This will store the timestamp the file, specified by gFilePath, was opened for the last time in the field lastAccessedDateTime.

Used in example file

Attribute.fmp12

Related functionsFunction badge

TrFile_GetTimeModified
TrFile_SelectFileDialog

Related topics

Troi File Plug-in online help (overview)


Online Help Page for Troi File Plug-in for 17 to 2024 –> TrFile_GetTimestampLastAccessed (filep4293) 2024-0604 19:20:11