Hi all,
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,
Kay.
______________________________________________________
Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!
Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au
Tools for developers: http://developer.perthweb.com.au
-- cfx_pwimageproc -- cfx_pwcardcrypt -- cfx_pwtextcrypt --
-- plus WindowsXP-compliant toolbar glyphs --
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
