On 8/28/01, Kay Smoljak penned:
>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?
There's no reason this shouldn't work:
#CreateODBCDate(createdate(form.year,form.month,form.day))#
If that throws an error then there is something wrong with the form
values you are passing.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
