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
