Thanks Martin, Steve - much appreciated. B.
On Jul 10, 5:48 pm, "Steve Onnis" <[EMAIL PROTECTED]> wrote: > Depending on the db platform your using i guess you could use some sql > string function to try and extract the date part our of the packet, convert > it into a date and do your compares like that. > > _____ > > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Matthew Bryant > Sent: Tuesday, 10 July 2007 6:38 PM > To: [email protected] > Subject: [farcry-dev] Re: original datetimecreated > > 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 Partnerhttp://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 -~----------~----~----~----~------~----~------~--~---
