<p>Yup, that's correct. The <code>craft_elements.dateCreated</code> column is the one that is referenced by the user's Join Date.</p>

<p>For the sake of being thorough, I prefer to copy that same value into <code>craft_users.dateCreated</code>, just as you have done.</p>

CC BY-SA 3.0
2015-12-29T11:24:14.307Z
That's great Lindsey, thanks. I don't suppose your familiar with the Import plugin? I'm wondering whether this can be adapted to update the join date when importing? It would obviously need to update it in both places.
shorn
CC BY-SA 3.0
2015-12-29T17:42:43.637Z
Sounds like a good [feature request](https://github.com/boboldehampsink/import/issues). Or even better, make the adjustment yourself and submit it as a pull request! Bob loves PR's.
Lindsey D
CC BY-SA 3.0
2015-12-29T18:16:29.120Z
Yea, I've requested it on Github. Doesn't seem to be much activity on it at the moment. Perhaps in the new year.  
I did try amending the plugin myself, but what ever I did didn't seem to make a difference. (Not familiar with plugin dev at all.)
shorn
CC BY-SA 3.0
2015-12-28T22:51:02.520Z
2015-12-28T22:51:02.520Z
Lindsey D
<p>I'm doing a big import of users from an EE install using the Import plugin. I can pull in all the details I need except the join date, so I looked at the craft db to see where it needs to be changed.</p>

<p>I successfully managed to change it by updating the <code>craft_elements</code> table, <code>dateCreated</code> column. This changed the join date in the control panel, however it does update the <code>dateCreated</code> column in the <code>craft_users</code> table so I updated there also. </p>

<p>Just wondering if thats correct?</p>

<users><import>
Updating a Users Join Date?
# Updating a Users Join Date?

(Asked by: username_0 on 2015-12-28)

I'm doing a big import of users from an EE install using the Import plugin. I can pull in all the details I need except the join date, so I looked at the craft db to see where it needs to be changed.

I successfully managed to change it by updating the `craft_elements` table, `dateCreated` column. This changed the join date in the control panel, however it does update the `dateCreated` column in the `craft_users` table so I updated there also.

Just wondering if thats correct?

**Tags:** users, import


---

## 1 answers

### Answer by username_1 on 2015-12-28. Score: 3 | Accepted answer

Yup, that's correct. The `craft_elements.dateCreated` column is the one that is referenced by the user's Join Date.

For the sake of being thorough, I prefer to copy that same value into `craft_users.dateCreated`, just as you have done.

> **Comments:**
> **username_0**: That's great Lindsey, thanks. I don't suppose your familiar with the Import plugin? I'm wondering whether this can be adapted to update the join date when importing? It would obviously need to update it in both places.  
> **username_1**: Sounds like a good [feature request](https://github.com/boboldehampsink/import/issues). Or even better, make the adjustment yourself and submit it as a pull request! Bob loves PR's.  
> **username_0**: Yea, I've requested it on Github. Doesn't seem to be much activity on it at the moment. Perhaps in the new year.   I did try amending the plugin myself, but what ever I did didn't seem to make a difference. (Not familiar with plugin dev at all.)  

---

