Set Timestamp Created
Sets the creation date/time of the file specified by the filePath.
Set Timestamp Created [ Select ; Result (error) ; FilePath ; Timestamp ]
|Select entire contents||replaces the entire contents of a field with the result. If not checked the result replaces the currently selected portion of the field|
|Result (error)||an error code|
|FilePath||the path to the file|
|Timestamp||new creation date/time of the file|
Data type returned
If successful it returns 0. If unsuccessful it returns an error code starting with $$ and the error code. Returned error codes can be:
|0||no error||the creation date/time was set|
|$$-43||fnfErr||the file was not found|
|$$-4241||the date/time is too big|
|$$-4245||the date/time is too small|
Troi File Plug-in 9.0
FileMaker Pro 16 to FileMaker Pro 2023
– macOS limits (using file system HFS+): on macOS the minimum representable date is January 1st, 1904 GMT. The maximum representable date is February 6, 2040 at 06:28:15 GMT.
– Windows limits: the minimum representable date is January 1st, 1980. The maximum date is December 31, 2107.
– The timestamps are in local time.
– On macOS it may take some time (about 5 secs) before the change is visible in the Finder. On Windows you need to refresh a Window before you see the change.
– Some file systems may not support creation time.
Set Timestamp Created [ Select ; gErrorCode ; "C:\test.doc" ; Timestamp ( Date ( 5 ; 09 ; 2017 ) ; Time ( 08 ; 59 ; 59 ) ) ]
This will set the creation date/time to May 9, 2017 at 08:59:59.
We assume that in your FileMaker file the following fields are defined:
gTheFile Global, text gTimestampCreated Global, timestamp gErrorCode Global, text
gFileSpec should contain the path to an existing file, for example “D:\Out.txt” (Windows) or “Mac HD:Out.txt” (Mac). gTimestampCreated should contain a valid date/time. In a script add the following script step:
Set Timestamp Created [ Select ; gErrorCode ; gTheFile ; gTimestampCreated ]
This will set the file’s creation date/time to the value in the timestamp field.
Related script step
|Set Timestamp Modified|