Imported Articles all show 1-1-1970 as date

Dolphin version 7.2.1

I imported articles into the database, changing a date string to unix timestamp.  All the dates for the articles are shown as 01-01-1970; the beginning of the unix epoch.

The timestamp in the database has been doubled check and is correct.  Why am I seeing this problem?  It is not showing on the demo site.  I created a new article and it posted with xx minutes ago.  Very puzzling as to why the imported articles are showing Jan 1 1970 as the date when the timestamps stored in the table are correct.

Had the same issue with upgrading to 7.1.6. Not all the articles were affected. I have no idea what the common factor in the date changed articles was.

The bx_arl_entries table has two date fields, `when` and `date`. Did you change both ?

Ah, I see. The date field in the backend is the "when" field and the creation date is automatically generated and fills the date field, is this correct? Thanks, this will be a simple fix; drop the entries and re-import with a few changes in the query. I have never used the articles module so was not familiar with it.

Thanks Modzzz; help truly appreciated.