Projects Tracker Start and Finish dates being set to 394652192

Problem

Dates in Projects Tracker list items upgraded from SharePoint 2010 render as 394652192.

Cause

SharePoint 2013 handles certain formulas in calculated columns differently.

Solution

Update the formulas in the Start Date and Finish Date calculated columns in the Projects Tracker list as below - essentially you need to insert a space between the "", as shown below.

Start Date

=IF(ISBLANK([Actual Start]),IF(ISBLANK([Planned Start]),"",[Planned Start]),[Actual Start])

to:

=IF(ISBLANK([Actual Start]),IF(ISBLANK([Planned Start])," ",[Planned Start]),[Actual Start])

Finish Date

=IF(ISBLANK([Actual Finish]),IF(ISBLANK([Current Finish]),IF(ISBLANK([Planned Finish]),"",[Planned Finish]),[Current Finish]),[Actual Finish])

to:

=IF(ISBLANK([Actual Finish]),IF(ISBLANK([Current Finish]),IF(ISBLANK([Planned Finish])," ",[Planned Finish]),[Current Finish]),[Actual Finish])