https://community.qlik.com/t5/Talend-Studio/How-to-get-Last-modified-date-from-tfileProperties/m-p/2306848#M78343 Hello, I want to extract file's last modified date and month. I am using tFileProperties (mtime_string) column but what I get is the date and time of file's last reference(i.e. when my job refers to tFileList and the file ultimately therein.) I am not modifying the file in anyway from my job. <BR />What I expect is ---- If the file is zipped on say 3rd May 2016 and my job is running on 5th May 2016 then I want last modified date of the file as 3rd May 2016. Plz note the file is zipped file. How can I achieve this ? I also tried using Java code as below but it gives the same result i.e date and time job is running : <BR /> <PRE>// assuming the correct filepath is given <BR />Long lastModified = file.lastModified();<BR />Date date = new Date(lastModified);</PRE> Thu, 05 May 2016 10:00:55 GMT _AnonymousUser 2016-05-05T10:00:55Z https://community.qlik.com/t5/Talend-Studio/How-to-get-Last-modified-date-from-tfileProperties/m-p/2306848#M78343 Hello, I want to extract file's last modified date and month. I am using tFileProperties (mtime_string) column but what I get is the date and time of file's last reference(i.e. when my job refers to tFileList and the file ultimately therein.) I am not modifying the file in anyway from my job. <BR />What I expect is ---- If the file is zipped on say 3rd May 2016 and my job is running on 5th May 2016 then I want last modified date of the file as 3rd May 2016. Plz note the file is zipped file. How can I achieve this ? I also tried using Java code as below but it gives the same result i.e date and time job is running : <BR /> <PRE>// assuming the correct filepath is given <BR />Long lastModified = file.lastModified();<BR />Date date = new Date(lastModified);</PRE> Thu, 05 May 2016 10:00:55 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-Last-modified-date-from-tfileProperties/m-p/2306848#M78343 _AnonymousUser 2016-05-05T10:00:55Z https://community.qlik.com/t5/Talend-Studio/How-to-get-Last-modified-date-from-tfileProperties/m-p/2306849#M78344 Hi, <BR />Could you please take a look at a related forum: <A href="https://community.qlik.com/s/feed/0D53p00007vCoPdCAK" target="_blank" rel="nofollow noopener noreferrer">https://community.talend.com/t5/Design-and-Development/Get-last-modified-date-of-a-file-and-perform-action/td-p/94376</A> to see if it works well for your use case? <BR />Best regards <BR />Sabrina Fri, 06 May 2016 05:51:15 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-Last-modified-date-from-tfileProperties/m-p/2306849#M78344 Anonymous 2016-05-06T05:51:15Z