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?
Printable View
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?
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...;)
For mbd, try:
"....where yourdate=cdate('" & format(date,"yyyy/mm/dd") & "')..."
For non mdb,
"....where yourdate='" & format(date,"yyyy/mm/dd") & "'..."