{"id":63413,"date":"2007-12-12T01:14:00","date_gmt":"2007-12-12T01:14:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2007\/12\/12\/hey-scripting-guy-how-can-i-delete-files-that-are-a-specified-number-of-hours-old\/"},"modified":"2007-12-12T01:14:00","modified_gmt":"2007-12-12T01:14:00","slug":"hey-scripting-guy-how-can-i-delete-files-that-are-a-specified-number-of-hours-old","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/hey-scripting-guy-how-can-i-delete-files-that-are-a-specified-number-of-hours-old\/","title":{"rendered":"Hey, Scripting Guy! How Can I Delete Files That Are a Specified Number of Hours Old?"},"content":{"rendered":"

\"Hey, <\/H2>\n

Hey, Scripting Guy! I\u2019ve seen scripts that let you delete all the files in a folder that are X number of days old. I have a different problem: I\u2019d like to delete files that are X number of hours, or even X number of minutes<\/I>, old. How can I do that?

— DF<\/P>\"Spacer\"\"Hey,\"Script<\/A> \n

Hey, DF. Did you see where some researchers are predicting that, by the year 2050, humans and robots might actually marry one another? In fact, outside of possible ethical concerns, these researchers see absolutely no reason why such marriages won\u2019t take place by the year 2050, at the latest.<\/P>\n

Although he\u2019s hardly an expert in robotics or artificial intelligence, the Scripting Guy who writes this column is a bit more skeptical. After all, look at the state of robotics today. For example, robots might be good at doing one thing (spot-welding an automobile on the assembly line; vacuuming a living room) but they\u2019re still more idiot savant than jack-of-all-trades. Robots aren\u2019t very good at conversation; robots pay no attention to your<\/I> feelings; robots are highly unlikely to give you a little something \u2013 not even a card \u2013 on your birthday. Robots can\u2019t fend for themselves; you have to do pretty much everything for them. Robots \u2013 <\/P>\n

You know, come to think of it, for the typical female, transitioning from the typical male to a robot probably won\u2019t be that big of a deal, will it?<\/P>\n

Interestingly enough, researchers are not<\/I> predicting that, by the year 2050, robots will be writing the Hey, Scripting Guy!<\/I> column. Many would say that\u2019s because some tasks are too trivial and too mindless even for robots. However, we like to believe that\u2019s because that no robot could ever write a script that, like this one, deletes all the files in the folder C:\\Scripts that are more than 8 hours old:<\/P>

strComputer = “.”<\/p>\n
Set objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)<\/p>\n
Set colFiles = objWMIService.ExecQuery _\n    (“ASSOCIATORS OF {Win32_Directory.Name=’C:\\Scripts’} Where ” _\n        & “ResultClass = CIM_DataFile”)<\/p>\n
strCurrentDate = Now<\/p>\n
For Each objFile In colFiles\n    strFileDate = WMIDateStringToDate(objFile.CreationDate)\n    intHours = DateDiff(“h”, strFileDate, strCurrentDate)\n    If intHours >= 8 Then\n        Wscript.Echo objFile.Delete\n    End If\nNext<\/p>\n
Function WMIDateStringToDate(dtmInstallDate)\n    WMIDateStringToDate = CDate(Mid(dtmInstallDate, 5, 2) & “\/” & _\n        Mid(dtmInstallDate, 7, 2) & “\/” & Left(dtmInstallDate, 4) _\n            & ” ” & Mid (dtmInstallDate, 9, 2) & “:” & _\n                Mid(dtmInstallDate, 11, 2) & “:” & Mid(dtmInstallDate, _\n                    13, 2))\nEnd Function\n<\/PRE>\n
OK, let\u2019s see if we can figure out how this baby works. (And no, we don\u2019t need any help from any of the robots reading this column. Although we apparently need help mixing a Tequila Sunrise<\/B><\/A>, we humans can still explain our own scripts, thank you very much.)<\/P>\n
As you can see (unless you\u2019re a robot, in which case your laser vision probably caught the computer screen on fire), we start out by connecting to the WMI service on the local computer. Just a moment; it looks like we question. You in the back, the one with the metallic voice. Can you run this script against a remote computer? You bet you can; all you have to do is assign the name of that remote computer to the variable strComputer, like so:<\/P>
strComputer = “.”\n<\/PRE>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. No, we don\u2019t have the remote computer\u2019s IP address. You\u2019ll have to ask her for that yourself.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
After connecting to the WMI service we then use this line of code, and an Associators Of<\/B> query, to retrieve a collection of all the files (instances of the CIM_DataFile<\/B> class) found in the folder C:\\Scripts. Once we have the collection in hand, we then assign the current date and time to a variable named strCurrentDate. That\u2019s what this line of code is for:<\/P>
strCurrentDate = Now\n<\/PRE>\n
At this point, we\u2019re ready to go and delete some files.<\/P>\n
To do that, our first step is to set up a For Each loop that loops through all the files in the folder C:\\Scripts. Inside that loop, the first thing we do is execute this line of code:<\/P>
strFileDate = WMIDateStringToDate(objFile.CreationDate)\n<\/PRE>\n
What\u2019s going on here? Well, what going on here is that we\u2019recalling a function named WMIDateStringToDate, passing the file\u2019s CreationDate<\/B> property as the function parameter. WMIDateStringToDate is going to take the CreationDate, perform a little formatting magi on that date, then store the reformatted value in a variable named strFileDate.<\/P>\n
Why do we go through all those gyrations? Well, as you know (and as even most robots know) WMI stores date-time values in the UTC (Universal Time Coordinate) format. Is that a problem? You bet it is; that means dates and times look like this:<\/P>
20071211094327.000000+420\n<\/PRE>\n
As you might expect, date arithmetic is none-too-easy when you have dates and times that look like that. Our function is designed to do something about that.<\/P>\n
We aren\u2019t going to talk about UTC dates and times today, nor are we going to explain the function WMIDateStringToDate function in any detail; if you\u2019d like more information on either of those topics, see the Microsoft Windows 200 Scripting Guide<\/B><\/A>. Instead, we\u2019ll simply note that the individual pieces of a typical date are actually stored at predefined locations within a UTC value; for example, the first four digits (2007) represent the year, the two digits after that represent the month; and so on. What our function is doing is simply taking a UTC value (the CreationDate property) and constructing a more readable (OK, OK: more human<\/I> readable) date from those various pieces. The net result? The variable strFileDate gets assigned a value like this:<\/P>
12\/11\/2007 09:43.27\n<\/PRE>\n
That\u2019s a value that humans find much easier to deal with. More importantly, it\u2019s also a value that VBScript finds easier to deal with.<\/P>\n
Speaking of which, as soon as we get the reformatted date-time value back from the function we hand that value off to VBScript and its DateDiff<\/B> function:<\/P>
intHours = DateDiff(“h”, strFileDate, strCurrentDate) \n<\/PRE>\n
What DateDiff does is determine the amount of time that has (or that will) elapse between two dates. As you can see, we pass three parameters when we call DateDiff:<\/P>\n\n\n\n\n\n
\u2022<\/TD>\n\n
“h”<\/B>. This represents the time interval we want to get back. We want to determine the age of a file in hours; hence we pass the value “h”. To get the age in minutes we\u2019d use this value: “n”<\/B>. For a complete list of parameters available to the DateDiff function see \u2013 you guessed it: see the Microsoft Windows 2000 Scripting Guide<\/B><\/A>.<\/P><\/TD><\/TR>\n
\u2022<\/TD>\n\n
strFileDate<\/B>. The date and time that the file was created.<\/P><\/TD><\/TR>\n
\u2022<\/TD>\n\n
strCurrentDate<\/B>. The current date and time. (Or at least the current date and time when the script first started.)<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
As we noted, DateDiff will calculate the age of the file in hours, then store that value in the variable intHours. We then use this line of code to determine if the file is more than 8 hours old:<\/P>
If intHours >= 8 Then\n<\/PRE>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. OK, technically we check to see if each file is greater than or equal to 8. Why? Because the DateDiff function returns integer values only, and constructs those integers by removing any decimal points (not by rounding up or down). For example, suppose a file is 8.5 hours (8 hours and 30 minutes old). In that case, DateDiff will report that the file is 8 hours old; because 8 isn\u2019t greater than 8, this file wouldn\u2019t be deleted. Using the greater than or equal to operator takes care of that problem.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
If the file is<\/I> older than 8 hours we then call the Delete<\/B> method and delete the file. If it isn\u2019t, then we simply zip back to the top of the loop and repeat the process with the next file in the collection. By the time we\u2019re done the only files left in C:\\Scripts will be those files less than 8 hours old. That\u2019s all we have to do.<\/P>\n
In case you\u2019re wondering, as part of his research the Scripting Guy who writes this column took a quick tour around the Internet looking for information about robots. When he did so, he stumbled upon Carebot 3.4<\/B><\/A>. One of Carebot\u2019s primary purposes in life is to follow you around everywhere you go, verbally reminding you of all the things you\u2019re supposed to be doing but apparently aren\u2019t doing at that very moment. <\/P>\n
You know, come to think of it, for the typical male, transitioning from the typical female to a robot probably won\u2019t be that big of a deal, will it?<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! I\u2019ve seen scripts that let you delete all the files in a folder that are X number of days old. I have a different problem: I\u2019d like to delete files that are X number of hours, or even X number of minutes, old. How can I do that?— DF Hey, DF. Did […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[715,13,38,3,4,12,5],"class_list":["post-63413","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-associators-of","tag-dates-and-times","tag-files","tag-scripting-guy","tag-scripting-techniques","tag-storage","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! I\u2019ve seen scripts that let you delete all the files in a folder that are X number of days old. I have a different problem: I\u2019d like to delete files that are X number of hours, or even X number of minutes, old. How can I do that?— DF Hey, DF. Did […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/63413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=63413"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/63413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=63413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=63413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=63413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}