Empty DateTime Field in Calculated Column

  …this post was published on 2016 May 17.

You need to check and maybe to use later if a Datetime field is empty or not?
Even if it is empty, that doesn’t mean that no value is there. The value stored inside is:
30.12.1899

In this case, the needed formula in a calculated column to check if a specifiv Date Field  [field_data] is empty will be:
=
IF(YEAR(field_data)=1899;“EMPTY”;“NOT EMPTY”)

This entry was posted in CalculatedColumn, Sharepoint. Bookmark the permalink.