AzureAD PowerShell更新用户入职日期遇数据类型错误求助

运行PowerShell脚本导入CSV文件，循环更新Azure AD用户的入职日期时，脚本逻辑看似正常，但触发了数据类型相关错误。想知道是需要修改CSV文件的日期格式，还是可以直接通过脚本转换现有日期。

错误信息 #

执行脚本时提示无法将CSV中的日期字符串转换为Azure AD要求的DateTime类型（对应原错误截图的核心问题）

原脚本代码 #

# Connect to Azure AD
Connect-AzureAD

# Path to the CSV file containing user data
$csvPath = "C:\Users\#######\Downloads\20231218_hire_date.csv"

# Import CSV data
$userData = Import-Csv -Path $csvPath

# Iterate through each user in the CSV and update their hire date
foreach ($row in $userData) {
    # Get the user by UPN (User Principal Name)
    $userPrincipalName = $row.'UserPrincipalName'
    $targetUser = Get-AzureADUser -Filter "userPrincipalName eq '$userPrincipalName'"

    # Check if the user is found
    if ($targetUser) {
        # Update the user's hire date attribute
        $hireDate = $row.'EmployeeHireDate'
        Set-AzureADUser -ObjectId $targetUser.ObjectId -ExtensionProperty EmployeeHireDate $hireDate
        Write-Host "Updated hire date for user $($user.UserPrincipalName) to $($user.EmployeeHireDate)"
    } else {
        Write-Host "User with UPN $($user.UserPrincipalName) not found."
    }
}

不需要修改CSV文件，直接在脚本里转换日期格式即可。核心原因是Import-Csv会把CSV里的所有值都读成字符串类型，但Azure AD的EmployeeHireDate扩展属性要求传入DateTime类型的参数，直接传字符串就会触发类型转换错误。

修改后的脚本 #

# Connect to Azure AD
Connect-AzureAD

# Path to the CSV file containing user data
$csvPath = "C:\Users\#######\Downloads\20231218_hire_date.csv"

# Import CSV data
$userData = Import-Csv -Path $csvPath

# Iterate through each user in the CSV and update their hire date
foreach ($row in $userData) {
    $userPrincipalName = $row.'UserPrincipalName'
    $targetUser = Get-AzureADUser -Filter "userPrincipalName eq '$userPrincipalName'"

    if ($targetUser) {
        # 将CSV中的日期字符串转换为DateTime类型，并加入异常处理
        try {
            $hireDate = [DateTime]::Parse($row.'EmployeeHireDate')
            # 用哈希表格式传递扩展属性，更规范
            Set-AzureADUser -ObjectId $targetUser.ObjectId -ExtensionProperty @{EmployeeHireDate = $hireDate}
            Write-Host "Updated hire date for user $($userPrincipalName) to $($hireDate.ToString('yyyy-MM-dd'))"
        } catch {
            Write-Host "Failed to parse hire date for user $($userPrincipalName): $_"
        }
    } else {
        Write-Host "User with UPN $($userPrincipalName) not found."
    }
}

额外注意事项 #

• 如果CSV中的日期是非标准格式（比如dd-MM-yyyy），可以用ParseExact指定格式，示例：

  $hireDate = [DateTime]::ParseExact($row.'EmployeeHireDate', 'dd-MM-yyyy', $null)
  

• 原脚本里输出时误用了未定义的$user变量，修改后统一用$userPrincipalName或$targetUser，避免报错

内容的提问来源于stack exchange，提问作者Ryan Rodlund