Fine then, take the much simpler route... See what I care ;oD
[crawls back under his o' so complicated rock] Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] Quoting Ben Bishop <[EMAIL PROTECTED]>: > Good ol' Thunderbird messing up my text :) > > I'm sure you got the idea: parseDateTime(queryname.date,"pop") > > Cheers, > > Ben > http://www.daemon.com.au/ > > > Ben Bishop wrote: > > > Hi Steve, > > > > You can use the function parseDateTime to convert a POP format > > datetime into UTC. > > |*ParseDateTime*|(/"/Wed, 19 Nov 2003 11:25:26 +1100/"/, /"pop/" ) > > > > Cheers, > > > > - Ben > > http://www.daemon.com.au/ > > > > > > [EMAIL PROTECTED] wrote: > > > >> hi y'all, > >> > >> i am popping some email and trying to display only those emails where > >> the date is greater than a given date, but am having some problems. > >> the date that is returned using the <cfpop> query is formatted like > >> this: Wed, 19 Nov 2003 11:25:26 +1100 > >> whereas i am trying to see if it is gt a date i have constructed > >> using createodbcdatetime: {ts '2003-11-19 11:23:55'} > >> what is the easiest way to convert the email date to a format that > >> will allow date comparison? the isdate(function) returns "NO" as it is. > > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
