(VBScript) SFTP Get File Date/Times in Different Formats

See more SFTP Examples

Demonstrates how to get remote file date/times in different formats.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

' This requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.SFtp")
set sftp = CreateObject("Chilkat.SFtp")

' Connect to the SSH server.  
hostname = "my-sftp-server.com"
port = 22
success = sftp.Connect(hostname,port)
If (success <> 1) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' Authenticate with the SSH server. 
success = sftp.AuthenticatePw("myLogin","myPassword")
If (success <> 1) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' After authenticating, the SFTP subsystem must be initialized:
success = sftp.InitializeSftp()
If (success <> 1) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' Open a directory on the server...
' This example opens the "junk" directory located under the HOME directory of the SSH user account.
handle = sftp.OpenDir("junk")
If (sftp.LastMethodSuccess <> 1) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' Download the directory listing:
' dirListing is a Chilkat.SFtpDir
Set dirListing = sftp.ReadDir(handle)
If (sftp.LastMethodSuccess <> 1) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' Close the directory handle
success = sftp.CloseHandle(handle)
If (success <> 1) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' Iterate over the files.
' Examine each filename and indicate those that match *FICHERO*.pdf
' (i.e. the filename contains the word "FICHERO" and ends in ".pdf")
i = 0
n = dirListing.NumFilesAndDirs
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbFilename = CreateObject("Chilkat.StringBuilder")
caseSensitive = 0
bLocalDateTime = 0
Do While i < n
    ' fileObj is a Chilkat.SFtpFile
    Set fileObj = dirListing.GetFileObject(i)
    outFile.WriteLine(fileObj.Filename)

    ' Get the last-modified date/time
    ' dt is a Chilkat.CkDateTime
    Set dt = fileObj.GetLastModifiedDt()

    ' Get the date/time in any format offered by the CkDateTime object.

    ' such as Wed, 18 Oct 2017 09:08:21 GMT
    outFile.WriteLine("RFC822 format: " & dt.GetAsRfc822(bLocalDateTime))

    ' such as 1990-12-31T23:59:60Z
    outFile.WriteLine("Timestamp: " & dt.GetAsTimestamp(bLocalDateTime))

    ' Such as: "02/16/2008 12:15:12"  where hour is 0 to 23.
    outFile.WriteLine("RFC822 format: " & dt.GetAsIso8601("MM/DD/YYYY hh:mm:ss",bLocalDateTime))

    i = i + 1
Loop

outFile.WriteLine("Success.")

outFile.Close