Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.5   8.0   8.1   8.2   8.3   8.4   8.5   9.0   9.1   9.2    Statistic  


Queries the access date of the file or folder.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
Files 2.9 Yes Yes Yes Yes Yes
MBS( "Files.AccessDate"; Path )   More


Parameter Description Example value
Path Native path to the file to check. "C:\test\me.jpg"


Returns timestamp or error.


Queries the access date of the file or folder.

Although the function is named date, it does return the time, too. Result is a timestamp.

This function requires a native path. Use Path.FileMakerPathToNativePath to convert a FileMaker path to a native path if required. If you like to have the user choose the path, you can use FileDialog functions.
For Server be aware that server has limited permissions and may not be able to access all files on a computer.


Queries access date of a file

MBS( "Files.AccessDate"; "C:\test.txt" )

Show files Dates:

MBS( "Files.CreationDate"; "C:\Users\Christian\Desktop\ddd.rtf" ) & " created" & ¶ &
MBS( "Files.ModificationDate"; "C:\Users\Christian\Desktop\ddd.rtf" ) & " modified" & ¶ &
MBS( "Files.AccessDate"; "C:\Users\Christian\Desktop\ddd.rtf" ) & " accessed"

See also

Example Databases

Blog Entries

Created 18th August 2014, last changed 17th July 2017

FileDialogWatcher.Install   -   Files.AddedToDirectoryDate

Feedback: Report problem or ask question.

MBS Xojo blog