I want that when I click the save button and the data is saved in GoogleSheet, the data_input is saved in 02Dec2024 format and not in DDMMYYYY
How do I do it?
Create a Google Sheets formula for that cell or column to convert the date to the format you want. You actually can do it without a formula by using custom date formats in Google Sheets.
If you do need a formula, use ChatGPT to create it for you.
1 Like