DATE FIELDS WILL NULL VALUES

[dunkindonut7777]

Hi I just have a problem removing the null values in a date format type of data. I already used the data cleansing tool but the null values remained. Can you help me solve this problem? Is there any tool to replace the null values into blank ?

[Qiu]

@dunkindonut7777 
You can do that. See attached sample.

[Emil_Kos]

Hi @dunkindonut7777,

If your data type is a date then you will not be able to change it to blank unless you will change it to a string.

I have tested it myself and after that I checked the formula and it confirmed my previous test:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Replace-nulls-in-DateTime-field-with-b...