Topics started by Mark_Roller

1 Topic

Mark_Roller
Mark_Roller
posted in Ask a Question

How do I interpret the timestamp?

Hello, we use Zapier to send our form submissions over to Quip to automatically insert them into a spreadsheet. When populating this spreadsheet, it’s nice to input a cell with a time/date stamp to identify when the form was submitted. At some point some things changed with Unbounce (or Zapier) and now there’s a “created at” field with a timestamp. That timestamp look’s like this - “2018-03-07T22:46:13.894Z”. Some of this is easily understood and some not. Here’s a guess: 2018-03-07T22:46:13.894Z Date - “2018-03-07” Time - “T22:46:13” No idea - “.894Z” Is the above correct? If so, what time zone is that? And what’s the ‘no idea’ part? Thanks in advance!

0
Hristian
6 years ago

Badge winners

Show all badges
Terms & ConditionsCookie settings