[thelist] RE: SQL: Infuriating Date/Time Insert

Frank framar at interlog.com
Thu Jan 4 15:07:08 CST 2001

>  Coming in late on this after holidays. I don't use CF,
>  but I bet I know the problem. 'Date' is a reserved word
>  for Access. If your field is so named, use [Date] (i.e.,
>  with square brackets) in the SQL code. Proper format for
>  date values in Access is #-delimited with no quotes.

May The Great Programmer upload blessings upon thy system!

The problem was indeed that I needed to format my date with the
pound signs (as was also mentioned by Matt). The second part of the
problem was that I had indeed a column named 'Date' and that by
renaming it to EventDate everything worked out fine.

You have no idea how helpful this was! May everyone's code parse
peacefully for the next 3 * CreateTimeSpan(1, 0, 0, 0)


Frank Marion                      Loofah Communications
frank at loofahcom.com               http://www.loofahcom.com

More information about the thelist mailing list