Hi,
I would like retrieve the date of a Excel file (in the reader). The date write in the Windows explorator.
I would like write this date in a field 'version' of my new file (in the writer)
Thanks a lot,
Solved
How retrieve the cration date of Excel file (reader)
Best answer by dustin
You can use the Directory and File Pathnames Reader to read the file (with Retrieve file properties set to yes). The attribute you are looking for is path_created_date, which can then be copied to the field 'version'. You might also find the path_modified_date to get the latest date.
+41- Evangelist
+30- Influencer
- Best Answer
You can use the Directory and File Pathnames Reader to read the file (with Retrieve file properties set to yes). The attribute you are looking for is path_created_date, which can then be copied to the field 'version'. You might also find the path_modified_date to get the latest date.
danilo_fme wrote:
Hi Danilo,
Thanks for your answer, but I think that the transformer DateTimeStamper give only the date of the day when you run your workbench. But I don't think is it possible to retrieve with this transformer the date of the file.
dustin wrote:
You can use the Directory and File Pathnames Reader to read the file (with Retrieve file properties set to yes). The attribute you are looking for is path_created_date, which can then be copied to the field 'version'. You might also find the path_modified_date to get the latest date.
Hi,
Thanks a lot, I used the transformer 'FilePropertyExtractor' and then I retrieve the field '_file_mtime'.
It's exactly that I want, thanks
1 person upvoted this
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.