Skip to main content

How to import list with date of birth/formatting issue?

I'm trying to import my list, including the DOB field. At first, I received an error message, saying, "born_at is not a valid format. This should be a date, like MM/DD/YYYY". I went into excel and realized there is no date format that matches the format NB is requesting. So, I had to create  custom format to apply to all cells in the column. I fixed that, tried to upload the newly saved file, then got the same error message. I think this is happening b/c although the cell shows the correct date format, when I click on the cell, the formula bar shows the original date format (ex, 3/13/2001 instead of 03/13/2001 like listed in the cell). Any suggestions?

Official response from

When importing, it is important to check "don't import" on your header row. It is likely that NationBuilder is trying to read the "born_at" header as a date, triggering the error. 

importrow.png

Share this post

Showing 5 reactions

How would you tag this suggestion?
Please check your e-mail for a link to activate your account.