Inserting sys date into Access database table

Hi All,

I have a problem with writing sys date into database. I am using Date() function in Vb.

I created date field ad Date/Time type in database and format is short(means 04/11/2002). When I am trying to insert a record into database table I am getting a error.

When I tried with out date field I was able to insert records into the database table.

Could someone please help me out in this matter. Could U pl send exact syntax If U can

Thnaks lot for UR help guys
Ram

The date format doesn't depend on what you have given, but depends on the system format. The custom formatting is only used by Access.