date?

[farizza]

hello
i have a textbox and in form load a write
Text1 = Format$(Date, "dd/mm/yyyy")
i run the form and show me the correct date.
my problem is when i insert in the database, insert mm/dd/yyy

¿what is the problem?

[D12Bit]

Hi,

Just asking...

Is your database a .mdb?

if it is, have you checked the format in the database
of the date field to be "dd/MM/yyyy"?

Saludos...

[jp_schwartz]

For mbd, try:
"....where yourdate=cdate('" & format(date,"yyyy/mm/dd") & "')..."

For non mdb,
"....where yourdate='" & format(date,"yyyy/mm/dd") & "'..."