If I load from an .XLS file from a network folder everything works fine and I can see the Last Modified Date by using the FileTime() method.
However, my problem is that the .XLS file I am loading from is hosted in Sharepoint and is accessed via a URL (rather than a UNC path). In this scenario I am not getting any information back from FileTime(). I have tried two methods:
1) LOAD *, FileTime() AS LastModifiedTime FROM '<url>' (biff);
2) LET lastModifiedTime = FileTime('<url>');
Is this a known issue? Does anyone have any suggestions?