# Adjust register date for user

**URL:** https://meta.discourse.org/t/adjust-register-date-for-user/187004
**Category:** Support
**Created:** [April 15, 2021, 7:32pm UTC](https://meta.discourse.org/t/adjust-register-date-for-user/187004 "2021-04-15T19:32:37Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![rmens](https://avatars.discourse-cdn.com/v4/letter/r/3ab097/32.png) [@rmens](https://meta.discourse.org/u/rmens)
#### Post date: [April 15, 2021, 7:32pm UTC](https://meta.discourse.org/t/adjust-register-date-for-user/187004/1 "2021-04-15T19:32:37Z")

</div>

Hi guys,

Today I had an unusual request after a migration where we skipped all accounts that never posted.

A user that had never posted, but values having an account, wanted his account back. I told him he could just re-register with his old username which he did. But now he wants to have his ‘member since’ adjusted to 2011, when he registered his old account…

Is there any way I can accomplish this?

---

<div class="post-metadata">

### Author: ![cocococosti](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cocococosti/32/231474_2.png) [@cocococosti](https://meta.discourse.org/u/cocococosti)
#### Post date: [April 17, 2021, 6:25am UTC](https://meta.discourse.org/t/adjust-register-date-for-user/187004/2 "2021-04-17T06:25:26Z")

</div>

By ‘member since’ do you mean the Joined section in your account summary?

 ![Screenshot_2021-04-17 Profile - cocococosti - Discourse Meta](https://global.discourse-cdn.com/meta/original/3X/0/6/06289947c3dcfda169bb30be13f8dfc54356586a.png)

If you have admin access to the server or database, you could edit the **created\_at** parameter for that user in the Users table.

You can do it from the rails console this way:

```
rails c
user = User.where(username: '<your-username-here>')
user.update(created_at: "2011-02-10 00:00:00.00000")

```

You could also do it directly in the Postgre database (although I don’t recommend it):

```
update public.users set created_at='2011-02-10 00:00:00.00000' where username = '<your-username-here>';

```

I tested this in my local environment and worked correctly:

Changed from:

 ![Screenshot_2021-04-17 Profile - costi abarca - Constanza's discourse(1)](https://global.discourse-cdn.com/meta/original/3X/9/f/9fe2509b00eaf88ccb7917f8b2e6e267bbebcfdb.png)

To:

 ![Screenshot_2021-04-17 Profile - costi abarca - Constanza's discourse](https://global.discourse-cdn.com/meta/original/3X/9/f/9fa102f319f67107dedc9b7fc2d91ad7ef01fc1b.png)

Please be very careful if you decide to go with this, I suggest you take a backup of the database before doing anything 😅

---

<div class="post-metadata">

### Author: ![rmens](https://avatars.discourse-cdn.com/v4/letter/r/3ab097/32.png) [@rmens](https://meta.discourse.org/u/rmens)
#### Post date: [April 17, 2021, 10:06am UTC](https://meta.discourse.org/t/adjust-register-date-for-user/187004/3 "2021-04-17T10:06:39Z")

</div>

Thanks a lot. That was the parameter I needed to change.

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [May 17, 2021, 10:07am UTC](https://meta.discourse.org/t/adjust-register-date-for-user/187004/4 "2021-05-17T10:07:13Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.