insert today's date

	Home Register Search Help Login

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

insert today's date

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> insert today's date

Page: [1]

barking mad

Posts: 287
Joined: 12/6/2002
From: Out in the sticks, UK
Status: offline

insert today's date - 10/4/2003 5:05:52

I've got a database with the field entrydate which is set to general date/time format

I'm simply trying to enter today's date into this field (along with some other info into the other fields) but I can't get it to work!

here's the error message

quote:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '#date#'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

& here's my DRW code (not on the DIET yet)

INSERT INTO entries (entrydate,affno,amount,place,county) VALUES (#date#, ::F1::, ::F4::, '::F2::', '::F3::')

any ideas would be appreciated

thanks

_____________________________

The more I ask, the more I learn, the more I' m confused, therefore the more I ask ...