ivonsurf123
Registered User.
- Local time
- Yesterday, 18:07
- Joined
- Dec 8, 2017
- Messages
- 69
Hello,
I am trying to update a date in the field AttendDate, that field contains the data for the whole year from 1/1/2018 till 12/31/2018, what I am trying to do is a query where can update is that field is missing a date per example date 9/24/2018 is not in that field. I was able to retrieve the whole data with a SELECT, but when I use an UPDATE query does not work, perhaps I am missing something, I run it and it comeback with 7/10/1905 dates in the whole field. Please, help.
I am trying to update a date in the field AttendDate, that field contains the data for the whole year from 1/1/2018 till 12/31/2018, what I am trying to do is a query where can update is that field is missing a date per example date 9/24/2018 is not in that field. I was able to retrieve the whole data with a SELECT, but when I use an UPDATE query does not work, perhaps I am missing something, I run it and it comeback with 7/10/1905 dates in the whole field. Please, help.
Code:
SELECT [AttendDate] FROM tbl_HolidayTracker
WHERE Year([AttendDate]) = Year(Date());
Code:
UPDATE tbl_HolidayTracker
SET [AttendDate] = Year(Date())
WHERE [Location] = '" & Me.cboCountry &"';
Last edited: