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?

Accepted Answer

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

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

Insert todays date into Access table using SQL

Solution

Problem