Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

File date created

Hi,
I need to recover the created date of et file...
I don't find it on the forum ...
Thanks.
TIS 3.0.2.
Labels (2)
14 Replies
_AnonymousUser
Specialist III
Specialist III

Hi
I am trying to do something similar
Simple TfileList --> TfileProperties --> TJavaRow
In the javarow I have the following code:
System.out.println("mtime = "+row2.mtime + " Converted date = " + TalendDate.formatDate("yyyy/mm/dd",new java.util.Date(row2.mtime)) + " row2.mtime_string = " + row2.mtime_string);
The output for the converted date is however invalid and does not match the mtime_string:
mtime = 1240347490000 Converted date = 2009/58/21 row2.mtime_string = Tue Apr 21 22:58:10 SAST 2009
mtime = 1240261066000 Converted date = 2009/57/20 row2.mtime_string = Mon Apr 20 22:57:46 SAST 2009
mtime = 1240261102000 Converted date = 2009/58/20 row2.mtime_string = Mon Apr 20 22:58:22 SAST 2009
mtime = 1240261130000 Converted date = 2009/58/20 row2.mtime_string = Mon Apr 20 22:58:50 SAST 2009
mtime = 1240261158000 Converted date = 2009/59/20 row2.mtime_string = Mon Apr 20 22:59:18 SAST 2009
mtime = 1240261184000 Converted date = 2009/59/20 row2.mtime_string = Mon Apr 20 22:59:44 SAST 2009
mtime = 1240347526000 Converted date = 2009/58/21 row2.mtime_string = Tue Apr 21 22:58:46 SAST 2009
mtime = 1240347558000 Converted date = 2009/59/21 row2.mtime_string = Tue Apr 21 22:59:18 SAST 2009
mtime = 1240347584000 Converted date = 2009/59/21 row2.mtime_string = Tue Apr 21 22:59:44 SAST 2009
Any help would be appreciated
Andre
Anonymous
Not applicable
Author

Hello Andre
change "yyyy/mm/dd" to "yyyy/MM/dd"
Best regards

shong
_AnonymousUser
Specialist III
Specialist III

Thank you, works perfectly.
Chaitanyas
Contributor
Contributor

Hi kzone,
I have a similar requirement, INPUT_ROW.mtime is returning the original file create date. similarly i need the last modified date of that particular file.
Could you please let me know what is the method to retrieve the last modified date.
Thanks in-advance!
Regards,
Chaitanya
Chaitanyas
Contributor
Contributor

Hi all,
I got the answer.
Thank you very much for this post. Its really help me a lot.
Especially thanks to kzone!!
Regards,
Chaitnaya