Time Function Handling Null Values

1. Overview

1.1 Problem Description

If there is a null value in the time field or the time format is incorrect, the null value and the value with incorrect time format will be defaulted to the current time when calculating the time field using the formula, as shown in the following figure:

1.2 Solutions

Use the IF function to handle null values.

2. Operation Steps

Change the original formula YEAR(Time) to if(ISNULL(Time), "", YEAR(Time))

As shown in the figure below: