can someone help with this formula, when there are no dates in the fields it returns 12/31/1969, i’d like it to return a blank or “none”
DATETIME_PARSE(
MAX(
IF({Last Entered Patrol Start Date (from Patrol Reports Section 1)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 1)}, 'x')), 0),
IF({Last Entered Patrol Start Date (from Patrol Reports Section 2)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 2)}, 'x')), 0),
IF({Last Entered Patrol Start Date (from Patrol Reports Section 3)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 3)}, 'x')), 0),
IF({Last Entered Patrol Start Date (from Patrol Reports Section 4)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 4)}, 'x')), 0),
IF({Last Entered Patrol Start Date (from Patrol Reports Section 5)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 5)}, 'x')), 0),
IF({Last Entered Patrol Start Date (from Patrol Reports Section 6)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 6)}, 'x')), 0),
IF({Last Entered Patrol Start Date (from Patrol Reports Section 7)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 7)}, 'x')), 0),
IF({Last Entered Patrol Start Date (from Patrol Reports Section 8)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 8)}, 'x')), 0),
IF({Last Entered Patrol Start Date (from Patrol Reports Section 9)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 9)}, 'x')), 0)
),
'x'