Simple question, I have a lot of data with date/time in a field. All the data is for 2020 but I want to change it to 2019.
10/02/20 11:09:53 becomes 10/02/19 11:09:53
10/02/20 13:48:08 Becomes 10/02/19 13:48:08
Effectively a query that looks up all the dates and just changes the year, not the day, month and time.
Any help would be greatly appreciated.
10/02/20 11:09:53 becomes 10/02/19 11:09:53
10/02/20 13:48:08 Becomes 10/02/19 13:48:08
Effectively a query that looks up all the dates and just changes the year, not the day, month and time.
Any help would be greatly appreciated.