Timestamp of a file

[#1]

Is it possible to read the timestamp of a file? There is a folder which contains multiple files in ti. I have to read the timestamps of all the files and load it.

[kristoferahlin]

filetime(YourFile) will give you the timestamp

Regards,

Kristofer

[its_anandrjs · Accepted solution]

Hi,

Yes is is possible try with

Load *,

FileTime() as TimeOfFile

From excel source;

Regards

Anand

[ashfaq_haseeb]

Hi,

filetime() as Date

Will get you time-stamp of your file.

Regards

ASHFAQ

[jagan]

Hi,

Check this link

Loop through Folders and sub folders to get file names

Set vConcatenate = ;

FileList:
LOAD
'' AS SourceFile,

'' AS Time
AUTOGENERATE 0;

SET vRoot = 'C:\QV Dashboards\';

                    for each FoundFile in filelist( vRoot & '\*.*' )

                              FileList:
                              LOAD '$(FoundFile)' as SourceFile,

                              filetime('$(FoundFile)')  AS Time
                               AUTOGENERATE 1;   

                    next FoundFile

Hope this helps you.

Regards,

Jagan.