Limiting Powershell Get-ChildItem by File Creation Date Range

powershell get-childitem
Nathan picture Nathan · Apr 8, 2013 · Viewed 111.5k times · Source

I use a Powershell command to generate a CSV report of certain file types. My goal is to find out how many were added during a particular date range. Right now, the script finds everything and I sort by date to find my number. I'd like to modify the command to only return objects within a creation date rage, i.e. if this file was created between 1 March 2013 and 31 March 2013. There's probably a way to limit the command by a date range, likely using Select-Object, I just can't figure it out.

Get-ChildItem 'PATH' -recurse -include @("*.tif*","*.jp2","*.pdf") | Select-Object FullName, CreationTime, @{Name="Mbytes";Expression={$_.Length/1Kb}}, @{Name="Age";Expression={(((Get-Date) - $_.CreationTime).Days)}} | Export-Csv 'PATH\scans.csv'

Answer

Nate Hekman picture Nate Hekman · Apr 8, 2013

Use Where-Object and test the $_.CreationTime:

Get-ChildItem 'PATH' -recurse -include @("*.tif*","*.jp2","*.pdf") | 
    Where-Object { $_.CreationTime -ge "03/01/2013" -and $_.CreationTime -le "03/31/2013" }

Related questions

Adding the file sizes of Get-ChildItem listing

My goal is to figure out how much space all images on my network drives are taking up. So my command to retrieve a list of all images is this: Get-ChildItem -recurse -include *jpg,*bmp,*png \\server01\folder Then I …

Read More
Use PowerShell to generate a list of files and directories

I'm writing a PowerShell script to make several directories and copy a bunch of files together to "compile" some technical documentation. I'd like to generate a manifest of the files and directories as part of the readme file, and I'd …

Read More
How to find files in directories with certain name using Get-ChildItem?

I have a project folder called topfolder and I want to find all files in all subfolders that match a certain pattern, e.g. when the folder contains foo anywhere in its name, I want to list all files inside …

Read More