cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to set Date Field to blank in Excel import?

Highlighted
Occasional Contributor

How to set Date Field to blank in Excel import?

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?

1 Reply
Highlighted
MEGA

Re: How to set Date Field to blank in Excel import?

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.

Jerome