XF 2.1 Change join date

Monkeytime

Active member
When we imported this forum, the forum's oldest member lost his join date when we merged his two usernames in the wrong direction. I'd like to honor his position by having his join date reflect the original launch 18 years ago.

It seems this questions comes up every now and then, but no obvious SQL answer. Can't find an addon either for 2.1.

So, I figure I'll just change it in sql, but this is what I find.

How do I transpose desired date into the date convention used by xenforo in this pic?
(this is not the user in question, just a random).

1594832432693.webp
 
I went to change the date with Brogan's reference tool, and it was already where it was supposed to be. I know I merged old to new because old forum is still live for verification. So, I misinterpreted what I saw after the merge, or there was a cron job cleanup that possibly corrected the join date to the older of the two after the fact?
 
Top Bottom