1
I have a project that adds and eliminates dates, to add I have the following code:
Set dbs = CurrentDb
dbs.Execute " INSERT INTO TMP " _
& "(diaMes) VALUES( " _
& "'" & tmp7 & "') "
where tmp7 is the date in dd-mm-yyyy and works perfectly
and to withdraw use of the following code:
Set dbs = CurrentDb
dbs.Execute " DELETE * FROM TMP " _
& "WHERE diaMes=#" & tmp7 & "#;"
The problem is that eliminating only eliminates if the day is over 12, ie I understand that if the day is less than or equal to 12 is interpreting as mm-dd-yyyy
tmp7 is a string with string concatenation.
How can I force SQL to pass as dd-mm-yyyy ?
The field in the table is like this:
Thanks friend, I tbm was with this problem. Thanks for the help!!
– Madison