05-07-2016 05:25 AM
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?
05-07-2016 10:12 AM
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.