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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+51- Celebrity
- 2077 replies
+31- Influencer
- 627 replies
- 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.
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.
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