1 Reply Latest reply on Nov 20, 2007 8:32 AM by c_wigginton

    search by date

    Mark Wheeler Level 1
      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