How to write the query for updating from same table every night?

What i want is how can i update amount from each ID everynight. For example Today date is 8 - 5 - 18 and if goes to 9 - 5 - 18 , i want like to update wallet date to be 9 - 5 - 18 date and amount should be previous date amount. Need query first and i can do it on task scheduling.

ID = 1 Amount '1000' Wallet Date = ' 8 - 5 - 18 ' ----

ID = 2 Amount '2000' Wallet Date = ' 8 - 5 - 18 ' ----

ID = 3 Amount '3000' Wallet Date = ' 8 - 5 - 18 ' ----

ID = 4 Amount '4000' Wallet Date = ' 8 - 5 - 18 ----

After Next Date ID = 1 Amount '1000' Wallet Date = ' 9 - 5 - 18 ' ----

ID = 1 Amount '1000' Wallet Date = ' 9 - 5 - 18 ' ----

ID = 1 Amount '1000' Wallet Date = ' 9 - 5 - 18 ' ----

ID = 1 Amount '1000' Wallet Date = ' 9 - 5 - 18 ' ----

Thanks you all.