Inserting sys date into Access database table

[Ram15]

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

[Cakkie]

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.