Insert todays date into Access table using SQL

Question

Im trying to use an SQL statement to insert the current date into an access table.

Ive got

DoCmd.RunSQL "INSERT INTO tblImportedData (dtmReportDate) VALUES Now();"

This isnt working. Anybody know what im doing wrong?

Amber · Accepted Answer · 2013-12-19 10:52:07Z

5

You need to put Now() between brackets like this:

INSERT INTO tblImportedData (dtmReportDate) VALUES (NOW())

answered Dec 19, 2013 at 10:52

Amber

8008 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dan · Accepted Answer · 2013-12-19 10:51:47Z

4

You need to put parenthesis around your list of values, even though there's only one column you're inserting into:

DoCmd.RunSQL "INSERT INTO tblImportedData (dtmReportDate) VALUES (Now());"

answered Dec 19, 2013 at 10:51

Dan

10.8k27 silver badges51 bronze badges

Comments

dylanT · Accepted Answer · 2016-08-05 00:10:21Z

3

For completeness, and because I came here looking for date, not datetime, if you need to enter the current date (as opposed to date and time) you can use:

DoCmd.RunSQL "INSERT INTO tblImportedData (dtmReportDate) VALUES (Date())"

answered Aug 5, 2016 at 0:10

dylanT

1,1101 gold badge13 silver badges28 bronze badges

Collectives™ on Stack Overflow

Insert todays date into Access table using SQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related