How to capture an Excel creation file date

[#1]

Can someone tell me how to capture an Excel file's creation date in the load? I am needing this date to create a calculated field called "Current Status" that will compare this date to another date to determine if the record is "Past Due", "Current" or "Future". Thanks for your help.

[brenner_martina]

Hi,

you can use the function FileTime() in your load statement:

Load field1, ...,

        filetime() As Datecreate

From Excel.xlsx (...);

Greetings from Munich

Martina

[#3 · Accepted solution]

Martina,

That works great!

Thanks for your help

Marcia

Message was edited by: bowermmc

[#4]

Hi Martina,

Can we capture the File Modified time the same way ?

Thanks in advance.

Best

Shyam