How to set Date Field to blank in Excel import?

[matthewfoo]

Hi there,

I was trying to set a Date field for mutiple record to blank using Excel import but not sure what value to set to. I have try empty cell , none, nil and 00/00/0000. But none of them work. any advice?

[jhorber]

Hello matthewfoo

1970/01/01 does not seem to work either

I am not aware of a conventional value that enables to initialize a date in Excel import wizard

The only solution I know is to use API script

Example

Set oObject = GetObjectFromId("~FABQ1g6OMn7M[0-test]")
oObject.SetProp("~fL4l7rh7pC10[Application Date]"),""

This may not be easy if the set of object does not match criteria that can be checked by a query

If you need to go further on this, please open a case.