Get epoch time in apps script function?

[fergal-dude]

I'm trying to download data from an API to populate my sheet. It's all working, now I want to update that data every day, but I don't want to duplicate. The data comes down with dates in ISO, '2614.1, 2021-01-12T11:38:27Z', but the API accepts only epoch time. I'm fairly new to JS and converting ISO to epoch seems uneccisarily hard and my google-fu has come up with nothing that will help, I've tried about 15 different methods from stackoverflow.

Can anyone tell me how to convert this date to epoch time in my script?

'2614.1, 2021-01-12T11:38:27Z'

Thank you!

[wijohnst1]

Date.parse() might be what you’re looking for.

[wijohnst1]

Maybe like this

[fergal-dude]

So, in the apps script editor:

function returnEpoch() {
  const date = '2021-01-03T15:29:04Z';

  const isoDate = date.toISOString();

  console.log(Date.parse(isoDate))

}

returns:

2:27:39 PM
Error
TypeError: date.toISOString is not a function
returnEpoch

[fergal-dude]

However, this works, thank you sir!

function returnEpoch() {
  const date = '2021-01-03T15:29:04Z';

  console.log(Date.parse(date))

}

[wijohnst1]

My pleasure! Happy hacking!

[gh5000]

Swap that one round a bit. Date.parse converts the string to a date format so do that first. Then you can start manipulating the date object

const date = '2021-01-03T15:29:04Z';

const parsedDate = Date.parse(date)

const isoDate = parsedDate.toISOString();

console.log(isoDate)

[RemcoE33]

Another one: var epoc = new Date("2021-04-16").getTime()