Use this query to update incorrect records (SQL Query):
- Select * from [AccInterest] where Not Convert(date, [ToDate]) = [ToDate]
- Update [AccInterest] Set [ToDate] = convert(date, [ToDate]) where Not Convert(date, [ToDate]) = [ToDate]
Use this query to select incorrect records (MS Access):
Select format([ToDate], "Short Date") , * from [AccInterest] where Not Format([ToDate], "Long Time") = "00:00:00"
Use this query update incorrect records (MS Access):
-
Update [AccInterest] Set [ToDate] = format([ToDate], "Short Date") where Not Format([ToDate], "Long Time") = "00:00:00"