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 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 -~----------~----~----~----~------~----~------~--~---
