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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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