如何在 SharePoint 中将日期格式从友好更改为标准？

问题：迁移到 SharePoint 2016 后，所有日期列都更改为“友好”格式！也就是说，日期字段开始显示“2 天前”、“大约一分钟前”、“3 小时前”、“今天下午 3:00”等值，而不是确切的日期。

如何将 SharePoint 中的显示格式从友好更改为标准？

要更改日期字段以以标准格式显示日期时间，请执行以下操作：

1. 转到列表设置 >> 选择字段以获取字段设置。

2. 您可以将格式从友好模式切换到标准模式。

   

PowerShell 禁用 SharePoint 日期列中的友好显示格式

让我们使用 PowerShell 禁用 SharePoint 列表的所有日期列中的友好日期格式。

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Config variables
$SiteURL="https://intranet.crescent.com"
$ListName="Projects"

#Get the List from the web
$Web = Get-SPWeb $SiteURL
$List = $Web.Lists[$ListName]

#Loop through each list field
ForEach($Field in $List.Fields)
{
    #Pick Date Columns
    If($Field.Type -eq "DateTime")
    {
        #Disable Friendly Display format
        $Field.FriendlyDisplayFormat="Disabled" #Relative
        $Field.update()               
        Write-Host -f Green "`t `t Field Updated:"$Field.Title
    }
}

将网站集的所有日期列中的友好日期格式更改为标准格式：

让我们使用 PowerShell 将 SharePoint 网站集中所有列表和库的所有日期列中的友好日期格式更改为标准日期格式。

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Set Site Collection variable
$SiteURL="https://intranet.crescent.com"

#Get All Webs of the Site Collection
$WebColl = Get-SPSite $SiteURL | Get-SPWeb -Limit All
 
#Iterate through each web
Foreach($Web in $WebColl)
{
    Write-host -f Yellow "Processing Web:"$Web.Url

    #Get All Lists of the web
    $ListColl = $Web.Lists

    #Loop through each list 
    Foreach($List in @($ListColl))
    {
        Write-Host -f Yellow "`t Processing List:" $List.Title
        
        $ListFields = $List.Fields
        #Loop through each field
        ForEach($Field in @($ListFields))
        {
            #Get the Field to suppress "Collection was modified" Error
            $Column = $List.Fields.GetFieldByInternalName($Field.InternalName)

            #Pick Date Columns
            If($Column.Type -eq "DateTime")
            {
                Write-Host -f Green "`t `t Field Updated:"$Column.Title

                #Disable Friendly Display format
                $Column.FriendlyDisplayFormat="Disabled" #Relative
                $Column.update()               
            }
         }
     }
}

PnP PowerShell 在 SharePoint Online 中禁用友好日期格式

使用此 PnP PowerShell 脚本禁用 SharePoint Online 中的友好日期格式：

#Parameters
$SiteURL = "https://crescent.sharepoint.com/sites/Retail"
$ListName = "Projects"
$FieldName = "Modified" #Internal Name

#Connect to SharePoint Online site
Connect-PnPOnline -Url $SiteURL -Interactive

#Disable Friendly Date Format
Set-PnPField -List $ListName -Identity $FieldName -Values @{FriendlyDisplayFormat = [Microsoft.SharePoint.Client.DateTimeFieldFriendlyFormatType]::Disabled}

如何更新网站集中所有列表和库中的所有日期和时间字段？

#Parameters
$SiteURL = "https://crescent.sharepoint.com/sites/Retail"
   
#Get Credentials to connect  
#$Cred = Get-Credential

#Connect to PnP Online  
Connect-PnPOnline -Url $SiteURL -Credentials $Cred  

#Get All Webs from the site
$Webs = Get-PnPSubWeb -Recurse -IncludeRootWeb

#Iterate through each web
ForEach($Web in $Webs)
{
    #Connect to web
    Connect-PnPOnline -Url $web.URL -Credentials $Cred
    Write-host -f Yellow "Processing Web:"$Web.URL
    
    #Get all lists and libraries of the web
    $Lists = Get-PnPList | Where {$_.Hidden -eq $false}
    ForEach($List in $Lists)
    {
        Write-host -f Yellow "`tProcessing List:"$List.Title
        
        #Get All Date Fields
        $Fields =  Get-PnPField -List $List | Where {$_.Hidden -eq $false -and $_.FieldTypeKind -eq "DateTime"}
        ForEach($Field in $Fields)
        {
            #Disable the modified column friendlyformat  
            Set-PnPField -List $List -Identity $Field.InternalName -Values @{FriendlyDisplayFormat = [Microsoft.SharePoint.Client.DateTimeFieldFriendlyFormatType]::Disabled}
            Write-host -f Green "`t`tUpdated Display Format for Field:"$Field.Title
        }
    }
}