date format in query

[xerife007]

hi forum,
If i make this query inaccess2000:

INSERT INTO T_Processo1 ( PK_Processo, Data_Inicio, PK_Cliente, ID_Proc_Banco, PK_Empregado )
VALUES ('30', #11-02-2001#, '1', "111", '1');

in field "Data_Inicio" apears 02-11-2001 and i want
11-02-2001. I use this in VB 6.0 and i had teh same problem.

Regards
PJM

 

[hymn]

Hi
have you thought of setting the date format in its TABLE

In the table in design view set field with the date in

Data Type = date/time
input mask in the box below set to short date

hope this helps