Created attachment 79071 [details]
Demo of FileDateTime() returning partially-garbage result
The FileDateTime(path) function is supposed to return a string giving the modification date & time of a file.
In 4.0 it became broken. It was working in 3.x.
Now you get results like "04/DD/YYYY 17:58:02"
For some reason the DD and YYYY are not replaced with values.
I will attach a trivial demo spreadsheet. The code in the macro is as follows:
Dim path : path = "/etc/passwd"
d = FileDateTime(path)
MsgBox "FileDateTime(" & path & ") = """ & d & """"
Operating System: Ubuntu
Version: 220.127.116.11 release
*** This bug has been marked as a duplicate of bug 63306 ***