How do I insert todays date using sql

[Serge]

What seaweed has said is right, the only thing is, it is to be used in Client/Server database, not Access.
GetDate function is a Transact SQL function, but in Access you CAN use Date(), Time(), Now() functions. Just bear in mind that you can not use the function by itself, i.e:

Select Date() As MyDate From MyTable

You have to use it in combination with a real fields, i.e:

Select FieldName, Date() As MyDate From MyTable