Why not just use soem regex and/or list funtions to remove the Wed, (',' as delimiter)
at the
beginning, and the +1100 at the end ('+' as delimeter) leaving you with:
19 Nov 2003 11:25:26
That should convert to an ODBC date time no worries.
Failing that - split it up via the space character, and you have your elements - day,
month,
year, time.
Could be a good fun time to leverage some Java and use java.util.StringTokenizer, but
that
could be overkill ;o)
HTH
Mark
------------------------------------------------------------------
[EMAIL PROTECTED]
ICQ: 3094740
Safe From Bees
[ www.safefrombees.com ]
Quoting [EMAIL PROTECTED]:
> 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.
>
> thanks,
>
> steve c
>
>
>
>
> ---
> 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
