Hi,
I have some code that retrieves the date/timestamp of a file and saves it into the variable showfileinfo, any ideas how can i get this formatted into a date/time field.?
Function IsFileModifed(filespec)
' This Checks The file as specified in Filespec and checks the modified time then writes a record in DB
Dim fso, f
Dim strSQL As String
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFile(filespec)
ShowFileInfo = f.DateLastModified
end function
I have some code that retrieves the date/timestamp of a file and saves it into the variable showfileinfo, any ideas how can i get this formatted into a date/time field.?
Function IsFileModifed(filespec)
' This Checks The file as specified in Filespec and checks the modified time then writes a record in DB
Dim fso, f
Dim strSQL As String
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFile(filespec)
ShowFileInfo = f.DateLastModified
end function