associates
Registered User.
- Local time
- Today, 11:31
- Joined
- Jan 5, 2006
- Messages
- 94
Hi,
I have a problem when updating the date in the table using sql in Access 03. When the current date is 2nd of Feb, the problem seems to arise. I don't have any problems if the day is greater than 12. It seems that when the day is less than 12, it gets confused as to whether it's a month or a day.
Here is my code
(Note: i set the date of my PC to the 8th of Feb 2008)
currDate = Format(Now, "dd/mm/yyyy")
strSQL = "UPDATE [Project Register] SET FirstCompletedFlag = '" & Me.CK_FirstMilestone.Value & "', FirstBudget = " & Me.TB_FirstBudget & ", FirstCompletedDate = #" & currDate & "#"
After the record was successfully updated, i went to check on the table. FirstCompletedDate has the value of 2/08/2008 (this is not what i wanted). It should be 8/02/2008, not the other way around.
Your help is greatly appreciated.
Thank you in advance
I have a problem when updating the date in the table using sql in Access 03. When the current date is 2nd of Feb, the problem seems to arise. I don't have any problems if the day is greater than 12. It seems that when the day is less than 12, it gets confused as to whether it's a month or a day.
Here is my code
(Note: i set the date of my PC to the 8th of Feb 2008)
currDate = Format(Now, "dd/mm/yyyy")
strSQL = "UPDATE [Project Register] SET FirstCompletedFlag = '" & Me.CK_FirstMilestone.Value & "', FirstBudget = " & Me.TB_FirstBudget & ", FirstCompletedDate = #" & currDate & "#"
After the record was successfully updated, i went to check on the table. FirstCompletedDate has the value of 2/08/2008 (this is not what i wanted). It should be 8/02/2008, not the other way around.
Your help is greatly appreciated.
Thank you in advance
