Moving files with Powershell

I have the powershell script below.

The intent is for the script to look for a specific drawing file in my source folder and move them to another folder.

The script is also designed to check if file have already been copied and skip over those files.

the script runs it generates a text file for the list of files but is empty and does not copy any files either.

Eventually I want this to run in task scheduler

# Set variables
$sourceFolder = "C:\mysource\folder"
$destinationFolder = "C:\mydestination\folder"
$extensionFilter = "*.hdf"
$zipFileName = "New_Drawings_$(Get-Date -Format 'yyyy-MM-dd').zip"
$processedFilesFile = "C:\mydestination\folder\myProcessedFiles.txt"

# Check if the processed files file exists and create it if it doesn't
if (!(Test-Path $processedFilesFile)) {
    New-Item -Path $processedFilesFile -ItemType File
}

# Get the list of files that match the extension filter in the source folder and its        subfolders and haven't been processed before
$fileList = Get-ChildItem -Path $sourceFolder -Recurse -Filter $extensionFilter | Where-Object {!($_.PSIsContainer) -and $_.LastWriteTime.Date -eq (Get-Date).AddDays(-1).Date -and (Get-Content $processedFilesFile) -notcontains $_.Name}

# Check if any files were found
if ($fileList.Count -gt 0) {
    # Create a new zip file with yesterday's date in the name
    $zipFileName = "New_Drawings_$(Get-Date).AddDays(-1).ToString('yyyy-MM-dd').zip"
    $zipFilePath = Join-Path $destinationFolder $zipFileName
    Compress-Archive -Path $fileList.FullName -DestinationPath $zipFilePath

    # Move the zip file to the source folder
    $zipFile = Get-Item -Path $zipFilePath
    $destinationPath = Join-Path $sourceFolder $zipFileName
    Move-Item -Path $zipFile.FullName -Destination $destinationPath

    # Add the names of the processed files to the processed files file
    $fileList.Name | Out-File $processedFilesFile -Append
}

is there a problem with my code or is it likely to be associated with a permissions issues? There are lots of files that meet the criteria and I have also tried with other file extensions and still doesn't work

thanks in advance for any help

The issue is with your date comparison, specifically where you have

$_.LastWriteTime.Date -eq (Get-Date).AddDays(-1).Date

as while the Get-Date part will return :

10/05/2023 00:00:00

the LastWriteTime.Date line will return both the date and time of the file's modified date.

So rather then -eq you need -ge to catch all times AFTER midnight of the chosen day. So like this

$fileList = Get-ChildItem -Path $sourceFolder -Recurse -Filter $extensionFilter | Where-Object {!($_.PSIsContainer) -and $_.LastWriteTime.Date -ge (Get-Date).AddDays(-1).Date -and (Get-Content $processedFilesFile) -notcontains $_.Name}

That's why if you'd tried outputting $filelist you'd have found it was empty, as none of the files were matching those conditions.