Time difference in date/time after migration
Notes always stores date/times as UTC values and if there is no specified time-value for a field - it is interpreted (and migrated) as midnight UTC. Then, if your SharePoint site is configured to use the GMT+N time zone, when these date/times are displayed as adjusted forward/backward by N hour(s)
Use a formula to convert the field values to the local time. Here is a Source Data Field you can try with the problem date/time field (specify Notes field name instead of Field_Name):
ColumnType => Formula
Formula => @TimeMerge(@Date(Field_Name); @Time(00;00;00))
Alias => Field_Name
Option => None
ReturnType => Date
If this field is then mapped to the SharePoint field, it should display as 12:00:00 AM in SharePoint (as in Notes).
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center