Forum Discussion
Managing a Master Dataset and Date Column Management
You may be able to use the "Replace Values" command in the "Transform" section of the "Home" ribbon of your query in edit mode to handle more complicated categorization. Remember to select the column you want to handle to enable the command.
Replace values won't work, as it is looking to preserve the date format and requires the replacement to be a legitimate date.
What is the specified data type for this column in the query? I just created a simple manual table with a data sample, and I'm not seeing the default behavior you mentioned. When my source data is NULL, weather I specify Date or Text data type, NULLS persist and are not replaced with 12/30/1899 as you described:
When I verify the results in my model, I see the same:
Where are you seeing the default 12/30/1899 values?