Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Martina,
That works great!
Thanks for your help
Marcia
Message was edited by: bowermmc
Hi,
you can use the function FileTime() in your load statement:
Load field1, ...,
filetime() As Datecreate
From Excel.xlsx (...);
Greetings from Munich
Martina
Martina,
That works great!
Thanks for your help
Marcia
Message was edited by: bowermmc
Hi Martina,
Can we capture the File Modified time the same way ?
Thanks in advance.
Best
Shyam