Update Query [Today's date]

[FlyGuyTray]

I have a table that I enter in the ID's of records that I want to do various updates on.. The database is a work tracking database, so as different tasks get complete, dates are entered into fields to reflect the work being complete. I am trying to simplify typing dates by building an update query that would select all the records in my aforementioned update table and update the "completion date" field to Today's date.. When using Today() in the "Update To" reference, i get the "Undefined function "Today" in expression" error. clearly I am leaving something out, but I am at a loss as to what.

Thanks in advance

 

[vbaInet]

It's Date()

 

[JANR]

Use Date() if you want to set current date in your table. If you want to include date and time, use Now()

JR

 

[FlyGuyTray]

**Smacks self in forehead** thanks folks!