hazeleyre23
Registered User.
- Local time
- Yesterday, 18:35
- Joined
- Apr 6, 2016
- Messages
- 18
Hi,
I have an update statement which works but only with dates 1st - 12th and I can't understand why.
The code updates the ToDate field with the new selected date. I have gone through all my code to see if I have put a block on it allowing dates between 13th -30th/31st but can find anything.
Am I missing something from my code?
Thanks
I have an update statement which works but only with dates 1st - 12th and I can't understand why.
Code:
Currentdb.Execute "UPDATE dbo_Agent_Data SET ToDate = #" & Me.txtUpdateToDate & "# , LogTime = '" & LogTime & "' WHERE id_NEW = " & Me.txtUpdateID & "", dbSeeChanges
The code updates the ToDate field with the new selected date. I have gone through all my code to see if I have put a block on it allowing dates between 13th -30th/31st but can find anything.
Am I missing something from my code?
Thanks