Date and time in sharepoint is ISO 8601 format. You could try the below script:
$spweb = get-spweb http://sp/sites/test/
$splist = $spweb.Lists.TryGetList("TestList")
$query = New-Object Microsoft.SharePoint.SPQuery
<FieldRef Name='Created' />
The only person that came help you with SPShell admin level access is another user who is already a SPShell admin.
If you are not having enough privileges and you try to get yourself added as an SPShell admin that won't work .
Use the below script to Update the Hyperlink field. Hope this may help you!
$ListName = "<Document Library>"
$FieldName = "URL"
$hyperLinkDisplayText = "Support Center"
$hyperLinkOldURL = "/sites/support" #Here you provide the old url which you want to search
$hyperLinkNewURL = "/sites/supportV2" #Here you provide the New ...
You can get a list of all of the items and write them to a csv using the script below. Make sure to replace the site name, list name, and fieldvalues.columnName before running.
$csv = "path/to.csv"
$List1 = Get-PnPList -Identity "List1Name"
$items = Get-PnPListItem -List $List1
foreach ($item in $items)...