topic Re: How to capture an Excel creation file date in QlikView

How to capture an Excel creation file date

Fri, 20 Jul 2012 15:42:07 GMT

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.

Re: How to capture an Excel creation file date

brenner_martina — Fri, 20 Jul 2012 15:48:34 GMT

Hi,

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

Load field1, ...,

filetime() As Datecreate

From Excel.xlsx (...);

Greetings from Munich

Martina

Re: How to capture an Excel creation file date

Fri, 20 Jul 2012 15:57:46 GMT

Martina,

That works great!

Thanks for your help

Marcia

Message was edited by: bowermmc

Re: How to capture an Excel creation file date

Wed, 11 Jan 2017 06:57:34 GMT

Hi Martina,

Can we capture the File Modified time the same way ?

Thanks in advance.

Best

Shyam