Default Date in Import

[Eric A]

I'm importing a CSV database, I get to the select columns to import and I have the option to replace Nulls with default value. Is there a way to change the default date (1/1/1970) to zero or blank. (or something other than a date)

Thanks!

[Bruce]

Eric

Quick answer no. The date field must have a date or null, (and a numeric field must have a number etc).

If you don't change the default to 1-1-1970 it will inport as null which is what I would consider a blank date.

What are you trying to do with this field? Using monarch I would use this null date in a calcuation with the IsNull() function.