How to manipulate "Date and Time" field values during migration (4324857)

When migrating content between site collections that are using different regional settings (time zone), the "Date and Time" values in the target are not same as the source. For example:

This normally happens because the Time Zone settings on the source and target site collections are different. SharePoint internally stores all "Date and Time" values in GMT/UTC. Content Matrix follows the same standard and updates all "Date and Time" values in UTC.

In the example above, the UTC value for "1/8/2014 7:00 PM (PST)" is "1/9/2014 3:00 AM (UTC/GMT)", which then becomes "1/8/2014 5:00 PM (Hawaii)" on the target after migration.

A custom transformer script can be used to alter the values in the "Date and Time" field during migration. Please follow the steps below:

1. Go to the Regional Settings in your source and target site collections to determine what offset needs to be added. In this example, we are going to add 2 hours to match the "Hawaii" time zone.
2. Launch the Content Matrix Console, right-click on the source list and choose Copy List.
3. Right-click on the target site and choose Paste List.
4. After choosing all the required options as per your requirement, click the Transformations tab.
5. On the Available Definitions section, select SharePoint Items.
6. Click Add Transformer and select Invoke PowerShell Script.
7. On the Configure PowerShell Transformer dialog window, click on the Transform tab, and then select Use Configured Script.
8. Modify the script below. Copy and paste it on the Use Configured Script field.
   
   Note: The script below increases the value in "Date and Time" field by 2 hours.

   if($dataObject["FSObjType"] -ne "1")
   {
    [datetime]$time = $dataObject["Propose_x0020_Time"]
    # Add 2 hours
    $time = $time.AddHours(2)
    # set the value. Add new line for each column
    $dataObject["Propose_x0020_Time"] = $time.tostring("o")
   }

    
9. Click OK, then run the job.

DISCLAIMER