Field help (ABIDATNUL)

This datamart parameter is used to manage X3 'null' dates in the universe.

Depending on the database type, the date 12-31-1599 will be replaced by null.

The date object select will display: a field that corresponds to the date field of the current table

• For Oracle:

"CASE WHEN " & Champ & " = '31-12-1599' THEN null Else " & Champ & " END COLCASE"

• For SQL-SERVER

"CASE {fn year(" & Champ & ")} WHEN 1753 THEN null ELSE " & Champ & "  END"