google app script how to get date in string date(spread sheet)

Question

I want to compare the date that was created in the spreadsheet with a specific date.

var ss = SpreadsheetApp.getActiveSpreadsheet();
var spreaddate = ss.getSheetByName("sheet123").getRange("B2").getValue();
//--> Thu Dec 12 00:00:00 GMT+09:00 2019
var comparedate = new date(yyyy-mm-dd)//somting like this
if(spreaddate > comparedate){
do something
}

The spreaddate is not recognized as a date. Even if I try to convert it to a date, it's hard because it's written in letters, not numbers like Thu Dec. What should I do?

If the output of spreaddate is "Thu Dec 12 00:00:00 GMT+09:00 2019", then it's probably a date. Your declaration of comparedate looks wrong, though. What's the exact error you're receiving? — Diego
– Diego, Commented Jan 24, 2020 at 7:14
Diego It's good to try again. I made a wrong date for the comparison. Thank you. — cloudbabby
– cloudbabby, Commented Jan 24, 2020 at 7:44

Diego · Accepted Answer · 2020-01-24 08:46:17Z

1

I think the problem is that you're not correctly defining your comparedate. You need to use a capital 'D' new Date().

answered Jan 24, 2020 at 8:46

Diego

9,5812 gold badges24 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

google app script how to get date in string date(spread sheet)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related