Alteryx replace null value to date

Question

When iam using this formula :

IF IsEmpty([FIRST APPEARED ON])

THEN [FIRST APPEARED ON]=DateTimeToday()
ELSE [FIRST APPEARED ON]
ENDIF

Null /Empty value is replaced with 1899-12-30 and not today's date..

BenMoss · Accepted Answer

Your formula is set up incorrectly it shpuld read...

If isempty([field])
Then datetimetoday()
Else [field]
End if

Ben