On Tue, 28 Aug 2001 09:06:15 +0800, "Kay Smoljak" <[EMAIL PROTECTED]>
wrote:
>Sorry for what is undoubtably a basic question, but I've been spoilt
>with SQL Server. I'm trying to insert a date into an Access database.
>The parts of the date have been split into their day, month and year
>components - and #createdate(form.year,form.month,form.day)# is
throwing
>a very unhelpful "syntax error" in Access. So is
>#createODBCDate(created_date)# (after assigning the results of
>createdate() to created_date). So how are dates meant to be formatted?
Thanks to everyone who replied. Turned out it was because I had single
quotes around the date functions. As we say in Australia, "how
embarrassment".
Kay.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
