Extract 'Modified Date' From File Name

[trentonponder]

Is there a method to pull the 'Modified' or 'created' date from a file when looping through 'All Files in a folder?'

[forumsupport]

Hello,

You can check for or get the files modified/created at particular date for e.g. you can get files created today, one day before, two days before likewise or files created between two dates using File.

If you can elaborate your requirement, we can provide appropriate solution.

Hope that helps.

[trentonponder]

I need to loop through a folder containing 50k files. For each file, I need to extract the name and created or modified date and insert the information into a database.

I understand your suggestion, but it would seem if there is a way to specify to only get files created within a particular date range that there would also be a way to extract the create date to a variable.

[forumsupport]

Hello,

In that case, we can create simple VB script to get the last modified date of given file and call this script from Automation Anywhere using 'Run Script' command. You can pass parameter to the command i.e the file path and can get modified date returned in Automation Anywhere variable, which you can insert into your database.

We have created a sample vb script and task for your convenience. To run this sample,

. Please copy .atmn under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.

. Copy .vbs under C:\.

. You may need to change the location of folder path at line #2 as per your requirement.

This task will log the filename and last modified date of respective file in C:\Temp.txt