search by date

[Mark_Wheeler]

Hey

Hope all had a good weekend, for me the silly season has well and truely taken hold :S

Got a verity index that brings back custom1 as the document date (modified) in cfMX 6.1. First the page does a cf search on the collection then creates a sql result of the collection ordered by date.

I had this code working perfectly previously and now the date conversion does not seem to want to play, would you suggest I use a number of mid(), rights() etc to get the date/time out of the returns from the collection? Below the list of dates:

Fri Sep 05 07:07:06 2003
Wed Jan 11 04:23:36 2006
Thu Aug 11 03:28:44 2005
Mon Aug 15 03:47:02 2005
Tue Apr 12 06:38:30 2005
Wed Feb 09 23:26:32 2005
Fri Dec 10 02:41:34 2004
Fri Aug 27 01:35:22 2004
Wed Jan 21 23:46:50 2004
Thu Sep 04 04:23:30 2003
Thu Sep 04 04:21:22 2003
Thu Sep 04 04:22:04 2003
Thu Sep 04 04:21:38 2003
Thu Sep 04 04:22:32 2003
Thu Sep 04 04:23:08 2003
Thu Sep 04 04:22:50 2003
Thu Sep 04 04:20:48 2003
Wed Sep 17 06:43:44 2003
Wed Sep 17 06:32:40 2003

with this list the first date is converted correctly with CreateODBCDate() then following error generated

Fri Sep 05 07:07:06 2003
{d '2000-09-05'}
Wed Jan 11 04:23:36 2006

The value "Wed Jan 11 04" could not be converted to a date.

Any help would be much appreciated.

Chrs
Mark W

[c_wigginton]

Java solution using CreateObject. Didn't have a verity query handy, so I created a quick list out of your Verity dates.