View original (French)

[Google Sheets] Script, Text + Date (DD/MM/YYYY)

Solved
Tatsu_Net Posted messages 8 Status Member -  
Tatsu_Net Posted messages 8 Status Member -
Hello,

- Here is the code that displays the date in format 
spreadsheet.getRange("A1").setValue(new Date()).setNumberFormat('dd/MM/YYY')
Result: 03/05/2019
- I tried to display the text "Last updated on: " in front of this date, but I can't find the right code
Result: Last updated on: Fri May 03 2019 20:24:49 GMT...
- I tried to manage this in another way 
spreadsheet.getRange("A1").setValue(new Date()).setNumberFormat('dd/MM/YYY') spreadsheet.getRange("A2").setValue("Last updated on: " + spreadsheet.getRange("A1").getValue())
but it seems that it does not take the text format into account
- I can't find a solution on the internet, maybe I'm not searching well
The final result should be like this: Last updated on: 03/05/2019

1 answer

Answer 1 / 1
Tatsu_Net Posted messages 8 Status Member 2
 
I found a solution by watching a video on YouTube: 
function Dates() { var spreadsheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var date = Utilities.formatDate(new Date(),"GMT", "dd/MM/yyyy"); spreadsheet.getRange("A1").setValue("Last updated on : " + date); };
1