Great... Works well, thx -----Original Message----- From: Ben Bishop [mailto:[EMAIL PROTECTED] Sent: Wednesday, 19 November 2003 11:51 AM To: CFAussie Mailing List Subject: [cfaussie] Re: date comparisons
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
