AnsweredAssumed Answered

Importing a list with boolean, date and nullable fields

Question asked by 60618 on Aug 3, 2014
Latest reply on Aug 7, 2014 by Edward Masson

What should be the data in the import file for fields of the following data types:

1) Boolean - "true","false","yes","no"

Subscribed,Company Name
True;Company AAA

2) DateTime - What format should it be? yyyy-mm-dd hh:mm:ss?

Is "2014-08-04T04:25:03Z" allowed?

3) To clear the existing value for a DateTime field, should the data be "null" or just an empty value? Is the example below valid?

Mobile Phone Number,Completed Date,Company Name
123456789,,Company AAA