Format a field

[Pilly170]

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

 

[RoyVidar]

Declare the ShowFileInfo variable with the datatype Date? Format the date when updating the table,

[tt]"#" & format(ShowFileInfo, "yyyy-mm-dd hh:nn:ss") & "#"[/tt]

Roy-Vidar

 

[Pilly170]

I knew it was simple. i been having a mare today. thanks.