After importing thousands of messages from a pop server, they display in Zimbra mail with a "Received Date" set to the date they were imported, rather than the original received date.
I'm sure there was a better way to import the messages that would have preserved the info (IMAP wasn't an option), but there it is.
So I have a need to alter the "Received Date" displayed in Zimbra Mail to match the sent date on the messages (which will be close enough). I assume this means a sql update script. But I'm having trouble guessing what columns in which tables need to be tweaked.
Any help appreciated!