0

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?

Improve this question
2
  • 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

Reset to default
2

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.

Improve this answer

Your Answer

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

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