{"id":52403,"date":"2009-09-23T03:01:00","date_gmt":"2009-09-23T03:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2009\/09\/23\/hey-scripting-guy-can-i-sort-files-by-creation-date\/"},"modified":"2009-09-23T03:01:00","modified_gmt":"2009-09-23T03:01:00","slug":"hey-scripting-guy-can-i-sort-files-by-creation-date","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/hey-scripting-guy-can-i-sort-files-by-creation-date\/","title":{"rendered":"Hey, Scripting Guy! Can I Sort Files by Creation Date?"},"content":{"rendered":"

\"Bookmark<\/a><\/p>\n

\"Hey,<\/span><\/span>Hey, Scripting Guy! I have a number of files that I work with based upon the date the file was created. I need an easy way to sort the listing of the files in a folder by creation date if possible. I am not sure this is even possible. When I look at the files in Windows Explorer, the date the file was created does not even appear. When I use the Windows PowerShell Dir<\/b> command, the creation date does not appear either. Is this something that Windows quit tracking? Or is the date a file was modified the same thing as the date the file was created?<\/p>\n<\/p>\n

<<\/p>\n

p style=”MARGIN: 0in 0in 8pt” class=”MsoNormal”>– JB<\/p>\n

\"Hey,<\/font><\/p>\n

Hello JB, <\/p>\n

Microsoft Scripting Guy Ed Wilson here. You know, when I am looking at pictures I took while I was scuba diving off the Little Caymans, such as the one following this paragraph, I often like to look at the creation date of the picture. In this way, I can match it up with the dates in my dive log and always remember where the picture was taken. In fact, because the time is also recorded in the creation date, I know not only where the picture was taken, but also the dive number. From my dive computer, I can look it up and tell you the water temperature, the maximum depth of the dive, the length of time I was in the water, the visibility, and all the other information (including the name of my dive buddy). <\/p>\n

\"Image<\/p>\n


Anyway, JB, you did not mention why you need to look at the creation date of the file, nor did you say the types of files with which you are working. But in reality, it does not matter. Because the SortFilesInFolderByCreationDate.ps1 script will accept a path<\/b> argument and a filter<\/b> argument, you can choose the folder and the file with which to work. The complete SortFilesInFolderByCreationDate.ps1 script is seen here.<\/p>\n

SortFilesInFolderByCreationDate.ps1<\/p>\n

<\/strong><\/p>\n

Param([string]$path, [string]$filter, [switch]$help)<\/p>\n

Function Sort-Files ([string]$path,[string]$filter)
{
 <\/span>Get-ChildItem -Path $path -Filter $filter |
 <\/span>Sort-Object -Property CreationTime
} #end Sort-Files<\/p>\n

Function Get-HelpText
{
 <\/span>$helpText = @”
DESCRIPTION:
  <\/span>Sorts files by creation date. Accepts parameter for path and file type.
EXAMPLE:
  <\/span>SortFilesInFolderByCreationDate.ps1 -path c:fso -filter “*.txt”
  <\/span>SortFilesInFolderByCreationDate.ps1 -p c:fso -f *.txt
  <\/span>SortFilesInFolderByCreationDate.ps1 c:fso *.txt
“@
 <\/span>$helpText
} #end Get-HelpText
# *** Entry point to Script ***<\/p>\n

if($help) { Get-HelpText ; exit }
Sort-Files -path $path -filter $filter |
Format-Table -property name, creationtime -AutoSize <\/p>\n

<\/font><\/font><\/span><\/p>\n

The SortFilesInFolderByCreationDate.ps1 Windows PowerShell script begins by creating three command-line parameters. This will allow you to change the directory location or the file type to sort without needing to actually edit the text of the script. The SortFilesInFolderByCreationDate.ps1 script also creates a switched parameter named help<\/b> that will display a help string when the script is run with the –help<\/b> switch. The command-line parameter statement is seen here: <\/p>\n

Param([string]$path, [string]$filter, [switch]$help)<\/p>\n

<\/font><\/span><\/p>\n

The main function in the SortFilesInFolderByCreationDate.ps1 script is the Sort-Files<\/b> function. It accepts the –path<\/b> parameter and the –filter<\/b> parameter for inputs. When the parameters for the function are defined, they are specified as strings. To ensure the input is an instance of the system.string<\/b> .NET Framework class, the class name is placed inside square brackets and it is used to constrain the value of the input parameter. An example of using this technique is shown here, where the number 15 is converted into a string value:<\/p>\n

PS C:> $a = [string]15
PS C:> $a.GetType()<\/p>\n

IsPublic IsSerial Name                                     <\/span>BaseType
——– ——– —-                                     <\/span>——–
True  <\/span>   <\/span>True     <\/span>String                                   <\/span>System.Object<\/p>\n


PS C:><\/p>\n

<\/font><\/span><\/p>\n

Inside the Sort-Files<\/b> function, the Get-ChildItem<\/b> cmdlet is used to obtain a listing of all the files in the specified folder that meet the filter criteria. An example of using the Get-ChildItem<\/b> cmdlet to display a listing of jpg files from the c:fso<\/b> folder is seen here:<\/p>\n

PS C:> Get-ChildItem -Path C:fso -Filter *.jpg<\/p>\n


    <\/span>Directory: C:fso<\/p>\n


Mode                <\/span>LastWriteTime     <\/span>Length Name
—-                <\/span>————-    <\/span> <\/span>—— —-
-a—        <\/span>10\/12\/2008   <\/span>7:26 PM    <\/span>9941280 LittleCayman_0122_edited-1.JPG<\/p>\n


PS C:><\/p>\n

<\/font><\/span><\/p>\n

After you have the collection of files that meet the filter criteria, the results are passed across the Windows PowerShell pipeline to the Sort-Object<\/b> cmdlet. The Sort-Object<\/b> has several parameters. The first parameter is the –property<\/b> parameter, which is used to specify which properties will be sorted. The –property<\/b> parameter will accept multiple properties, but in general its usefulness seems to breakdown after two or three properties to sort on. The other main parameter you will want to use is the –descending<\/b> switched parameter. By default Windows PowerShell sorts in ascending order. The sorting is done in a case-insensitive fashion unless the –casesensitive<\/b> switched parameter is used. You also have the ability to use the –unique<\/b> switched parameter to cause the Sort-Object<\/b> cmdlet to return only unique values. The use of the Sort-Object<\/b> cmdlet is illustrated here:<\/p>\n

PS C:> Get-ChildItem -Path C:fso -Filter *.txt | Sort-Object -Property name -Descen
ding<\/p>\n


    <\/span>Directory: C:fso<\/p>\n


Mode                <\/span>LastWriteTime     <\/span>Length Name
—-                <\/span>————-     <\/span>—— —-
-a—         <\/span>9\/15\/2009   <\/span>5:30 PM         <\/span>20 IwasHere.txt
-a—         <\/span>9\/14\/2009  <\/span>12:09 PM          <\/span>0 8907.txt
-a—         <\/span>9\/14\/2009  <\/span>12:09 PM          <\/span>0 5678.txt
-a—         <\/span>9\/14\/2009  <\/span>12:09 PM          <\/span>0 2456.txt
-a—         <\/span>9\/14\/2009  <\/span>12:09 PM          <\/span>0 1356.txt
-a—         <\/span>9\/14\/2009  <\/span>12:09 PM          <\/span>0 1345.txt
-a—        <\/span> <\/span>9\/14\/2009  <\/span>12:09 PM          <\/span>0 1234.txt<\/p>\n


PS C:><\/p>\n

<\/font><\/span><\/p>\n

The complete Sort-Files<\/b> function is seen here: <\/p>\n


Function Sort-Files ([string]$path,[string]$filter)
{
 <\/span>Get-ChildItem -Path $path -Filter $filter |
 <\/span>Sort-Object -Property CreationTime
} #end Sort-Files<\/p>\n

<\/font><\/span><\/p>\n

When a script uses command-line parameters, it is a best practice to implement some kind of Help system for the user of the script to know which parameters are available and what sample syntax might look like. It is important to do this, even if you do not intend to share the script with anyone else. In Windows PowerShell 2.0, you will be able to use the Get-Help<\/b> cmdlet to provide Help for your script, but in Windows PowerShell 1.0 there is no such feature. <\/p>\n

To make your script display Help in a systematic fashion, use the Get-HelpText<\/b> function. The Get-HelpText<\/b> function uses a here-string<\/b> to store the Help text in a variable named $helpText<\/b>. The here-string<\/b> begins with the at symbol and quotation mark (@”<\/b>), and it ends with the quotation mark and the at symbol (“@). Between the tags, everything is interpreted as text. The first advantage of using a here-string is that it allows you to dispense with typing quotation marks at the beginning and end of each line. The second advantage is that it allows you to ignore quoting rules and issues with escaping the quotation marks inside a text string. The use of the back tick (`) symbol to escape a quotation mark inside a string is illustrated here: <\/p>\n

PS C:> “This is a “string” with a quote in it”
Unexpected token ‘string with a quote in it’ in expression or statement.
At line:1 char:39
+ “This is a “string” with a quote in it” <<<<
PS C:> “This is a `”string`” with a quote in it”
This is a “string” with a quote in it
PS C:><\/p>\n

<\/font><\/span><\/p>\n

The contents of the here-string<\/b> are assigned to the $helpText<\/b> variable in the Get-HelpText<\/b> variable. The last thing the Get-HelpText<\/b> function does is to display the contents of the $helpText<\/b> variable. This is seen here: <\/p>\n


Function Get-HelpText
{
 <\/span>$helpText = @”
DESCRIPTION:
  <\/span>Sorts files by creation date. Accepts parameter for path and file type.
EXAMPLE:
  <\/span>SortFilesInFolderByCreationDate.ps1 -path c:fso -filter “*.txt”
  <\/span>SortFilesInFolderByCreationDate.ps1 -p c:fso -f *.txt
  <\/span>SortFilesInFolderByCreationDate.ps1 c:fso *.txt
“@
 <\/span>$helpText
} #end Get-HelpText<\/p>\n

<\/font><\/span><\/p>\n

The entry point to the script first checks for the existence of the $help<\/b> variable. If the $help<\/b> variable is found, it means the script was run with the –help<\/b> parameter, and the user of the script wishes to see the Help message. The Get-HelpText<\/b> function is called, and the Help text is displayed. The script is then exited by using the exit<\/b> statement. This is seen here: <\/p>\n

if($help) { Get-HelpText ; exit }<\/p>\n

<\/font><\/span><\/p>\n

When the script is run with the –help<\/b> switched parameter, the Help message is displayed on the Windows PowerShell console. This is seen here:<\/p>\n

PS C:> C:ScriptingGuysSortFilesInFolderByCreationDate.ps1 -help
DESCRIPTION:
  <\/span>Sorts files by creation date. Accepts parameter for path and file type.
EXAMPLE:
  <\/span>SortFilesInFolderByCreationDate.ps1 -path c:fso -filter *.txt
  <\/span>SortFilesInFolderByCreationDate.ps1 -p c:fso -f *.txt
  <\/span>SortFilesInFolderByCreationDate.ps1 c:fso *.txt
PS C:><\/p>\n

<\/font><\/span><\/p>\n

If the $help<\/b> variable is not present, it means the script was not run with the help<\/b> switched parameter, because the only way the $help<\/b> variable will exist is if it is supplied from the command line. After checking for the help<\/b> variable, the script calls the Sort-Files<\/b> function. The values for the –path<\/b> and –filter<\/b> parameters are collected from the Windows PowerShell command line. The results from the Sort-Files<\/b> function are passed back to the Format-Table<\/b> cmdlet. The name<\/b> and the creationtime<\/b> properties are selected from the System.Io.FileInfo<\/b> .NET Framework class, and the –autosize<\/b> parameter is used to tighten up the data that is displayed on the Windows PowerShell command line. This section of the script is shown here: <\/p>\n

Sort-Files -path $path -filter $filter |
Format-Table -property name, creationtime -AutoSize<\/p>\n

<\/font><\/span><\/p>\n

Well JB, that is about all there is to know about using the Get-ChildItem<\/b> cmdlet and the Sort-Object<\/b> cmdlet to find the creation date from your files and display a formatted list. <\/p>\n

If you want to know exactly what we will be looking at tomorrow, follow us on Twitter<\/a> or Facebook<\/font><\/a>. If you have any questions, send e-mail to us at scripter@microsoft.com<\/a> or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n

 <\/p>\n

Ed Wilson and Craig Liebendorfer, Scripting Guys<\/p>\n

<\/span><\/b><\/p>\n

<\/span><\/font><\/font> <\/p>\n","protected":false},"excerpt":{"rendered":"

Hey, Scripting Guy! I have a number of files that I work with based upon the date the file was created. I need an easy way to sort the listing of the files in a folder by creation date if possible. I am not sure this is even possible. When I look at the files […]<\/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":[38,3,12,45],"class_list":["post-52403","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-files","tag-scripting-guy","tag-storage","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Hey, Scripting Guy! I have a number of files that I work with based upon the date the file was created. I need an easy way to sort the listing of the files in a folder by creation date if possible. I am not sure this is even possible. When I look at the files […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/52403","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=52403"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/52403\/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=52403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=52403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=52403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}