I have to import small quantity of contacts with custom date field. Field is set as rrrr (which should be filled with 4-digits year - 2017). Every single time, when this year is added in csv file I've got error 'Invalid value for field(s)'.

Value is set as 2015.

What may be the cause of that?

  • 1
    i think you need to import as eg 2015-01-01. also what do you mean by rrrr. is that a typo for yyyy?
    – petednz - fuzion
    Aug 23, 2017 at 19:48
  • Yes, I ment yyyy (rrrr is symbol in my language :)) I've just check database for this value that is being saved when I type 2015 and it is saved as '2015-01-01 00:00:00'
    – Zglanowany
    Aug 23, 2017 at 20:48

1 Answer 1


petednz - fuzion was right. Type of data that can be selected during custom field setup is related to data. display, not to data type. Database needs full date (even if field was setup as yyyy). Adding 01-01 helped.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.