Forum Discussion
Managing a Master Dataset and Date Column Management
I have a master dataset of approximately 2.5MM rows. There are a number of columns that contain various date columnsrepresenting Start/End dates. Not all these date columns apply to every row...
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?