Author Topic: Can't get an import of dd/mm dates.. wants dd/mm/yy. (Read 1363 times)

Shefftini · March 29, 2012, 11:08:00 am

We are trying to import birthdates without the year into our membership database. The import form only shows date formats that include the year in some form, so we get errors when it only sees dd/mm. We could of course do it as a text only field within but then we could not do a sort between dates. No problem setting up the data field within CiviCRM for dd/mm.. just getting the data in from an external excel roster.

Got a work around?

Hershel · March 29, 2012, 12:48:21 pm

What I would do is select the column in Excel or OpenOffice, copy and paste it into a good text editor. Download a free programmer's editor if you don't have one.

Then do a search and replace for the "newline" character which is represented by \n in many editors. Replace that with /1900\n so that each birthday has a year, albeit the year 1900.

Then copy and paste the whole thing back into Excel or OpenOffice, into that selected column.

At least you can import them as dates then.

CiviCRM Community Forums (archive)

News:

Author Topic: Can't get an import of dd/mm dates.. wants dd/mm/yy. (Read 1363 times)

Shefftini

Can't get an import of dd/mm dates.. wants dd/mm/yy.

Hershel

Re: Can't get an import of dd/mm dates.. wants dd/mm/yy.