How to highlight certain values ​​by date?

Question

PowerShell

I welcome everyone!
There is a script that collects certain events from the server logs.

$servername = "111.domain.com"
$username = "DOMAIN\user"
 
[xml]$equery = @"
<QueryList>
    <Query Id="0" Path="Microsoft-Windows-TerminalServices-Gateway/Operational">
    <Select Path="Microsoft-Windows-TerminalServices-Gateway/Operational">*[System[(EventID=303)]] and *[UserData[EventInfo[(Username='$username')]]]</Select>
    </Query>
</QueryList>
"@
Get-WinEvent -ComputerName $servername -FilterXML $equery |
   Select-Object TimeCreated, @{Name="SessionDuration";Expression={$_.Properties[6].Value}},
                              @{Name="User";Expression={$_.Properties[0].Value}},
                              @{Name="Source Network Address";Expression={$_.Properties[1].Value}},
                              @{Name="Resource";Expression={$_.Properties[3].Value}},MachineName | Out-GridView

Question for PowerShell experts - how to sort the output by date and add the SessionDuration values ​​for the selected date?

Answer 1

1. ... | Sort-Object -Property TimeCreated
2.

$date = [datetime]'2020-04-13';

... |
   Where-Object { $_.TimeCreated.Date -eq $date } |
   Measure-Object -Sum -Property SessionDuration

Well, further to taste