Alteryx replace null value to date

[Samals]

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 solution]

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

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

Ben

[Samals]

Works Perfectly! Thank you