Today's date in Access

From: James (anonymous_at_discussions.microsoft.com)
Date: 06/20/04 

Date: Sun, 20 Jun 2004 00:10:17 -0700

How can I use a form button to insert today's date in a
table, to leave a transction log?

I have tried putting the current date in a SQL string
that I run with doCmd in VBA, but if the data type in the
table is date/time, I get rubbish (31/12/1899, or some
such). It looks OK if I change the data type in the
table to string, but I need it to be a date type for
calculation.

This would be dead easy in Oracle.

Thanks

James