Hi B, The original creation date is stored in the datetimecreated field inside the wddx packet of dmArchive. Not very useful for reporting, but handy enough to find out the original datetimecreated.
Kind regards -- -- Matthew Bryant Product Development Manager Daemon Internet Consultants Adobe Solutions Partner http://www.daemon.com.au/ p. 02 9380 4162 f. 02 9380 4204 On 10/07/2007, at 2:43 PM, bsmith wrote: > > OK maybe this isn't as straightforward as I imagined. It seems that > neither the dmArchive or the dmHtml tables have a reliable creation > date - or perhaps my method is wrong. > > Anyone know a reliable way to determine the original creation date for > content? > > B. > > > > On Jul 5, 11:40 am, bsmith <[EMAIL PROTECTED]> wrote: >> right, my bad. I was comparing dmHtml.objectID to dmArchive.objectID >> instead of dmArchive.archiveID >> >> B. >> >> On Jul 5, 11:26 am, bsmith <[EMAIL PROTECTED]> wrote: >> >>> Hi All, >> >>> I'm just trying to get a report going that relies on the original >>> creation date. The datetimecreated in the dmHtml table is that of >>> the >>> current version of the item at that objectID - is there a way for me >>> to get the creation date of the original dmHtml record, the first >>> version? >> >>> B. > > > > > -- > Message protected by MailGuard: e-mail anti-virus, anti-spam and > content filtering. > http://www.mailguard.com.au/mg > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
