Google Sheets - how to script a new sheet with a specific name (date)?

Question

Google Apps Script

Good afternoon !

There is a table with sheets 03/05/2022, 03/06/2022, 03/07/2022, etc.

please tell me how to make a script to create a new sheet with a specific name
after the next one - say 03/08/2022 and at the same time copy all the data from the previous sheet?

Answer 1

var source = SpreadsheetApp.getActiveSpreadsheet();
var sheet = source.getSheets()[0];

sheet.copyTo(source).setName('newName');

Here is the code for duplicating sheets