Mailing event time stamp

[timfluhr]

Hi everyone.

I have a strange problem.  For many of my civicrm mailings the civicrm_mailing_event_delivered_time_stamp value is set to NULL.  I noticed this when building a drupal view to search for mailings and sort them by delivered date.  I'm not sure of a couple things:

1.  Why/how this became the case.
2.  Where in the database I can go to manually change the value from NULL to something else so it shows up in the views I am creating.

This is 4.2.14 instance of civi running on D6.  Does anyone have any insight?

Thanks!

-tim

[timfluhr]

Hey all.

I'm still kind of stuck on this.  I basically have a bunch of mailings will null values for event_delivered_time stamp.

I would like to fix these manually (at the very least) so they will show up correctly in views I've created, but I can't figure out where in the database to change the value from NULL to some real date.

-tim