SP2016 Copy specific records from big list to anther list with PowerShell

Question

I was able to copy all records from a big list to another list but not able to copy specific records form source list to the destination list using PowerShell as below, Any Help Please.

$web = Get-SPWeb $WebURL

$SourceList = $web.Lists[$SourceListName]

$TargetList = $web.Lists[$TargetListName]

$SourceColumns = $sourceList.Fields

#$SourceItems = $SourceList.GetItems();

$souceItems= $SourceList.items | where {$["created"] -gt '1/1/2015' -and $["created"] -lt '1/1/2020'};

$souceItems.Count;

Foreach($SourceItem in $SourceItems)

{ $TargetItem = $TargetList.AddItem()

Foreach($column in $SourceColumns) 

{
    if($column.ReadOnlyField -eq $False -and $column.InternalName -ne "Attachments")

    {
         $TargetItem[$($column.InternalName)] = $sourceItem[$($column.InternalName)];
    }
}

$TargetItem.Update(); }

Answer 1

Modify your Powershell command to:

$web = Get-SPWeb $WebURL
$SourceList = $web.Lists[$SourceListName]
$TargetList = $web.Lists[$TargetListName]

$SourceColumns = $sourceList.Fields

$caml='<Where>
   <And>
    <Gt>
        <FieldRef Name="Created" />
        <Value IncludeTimeValue="TRUE" Type="DateTime">2015-1-1T12:00:00Z</Value>
    </Gt>
    <Lt>
        <FieldRef Name="Created" />
        <Value IncludeTimeValue="TRUE" Type="DateTime">2020-1-1T12:00:00Z</Value>
    </Lt>
   </And>
   </Where>'
  
$query=new-object Microsoft.SharePoint.SPQuery
$query.Query=$caml | Write-Output

$SourceItems=$Sourcelist.GetItems($query)

Foreach($SourceItem in $SourceItems)
{
    $TargetItem = $TargetList.AddItem()
    Foreach($column in $SourceColumns) 
    {
        if($column.ReadOnlyField -eq $False -and $column.InternalName -ne 
"Attachments")
        {
             $TargetItem[$($column.InternalName)] = 
$sourceItem[$($column.InternalName)];
        }
    }
   $TargetItem.Update();
}