1 Reply Latest reply: May 15, 2014 10:02 AM by Bruce _ RSS

    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!

        • Default Date in Import
          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.