The Time format in app logins

how do you break that info 2020-01-14T17:39:48.939Z 2020= yr 01= month 14= day T = time
now how to decipher the rest 39:48:939 and what is the Z

Hi @Woody, this question has already been replied in this forum, by @Jeff_Hager and others. Do not hesitate to search in the forum to get answers.

Hereafter a link that will help I guess :
Help. Calendar view not displaying correctly

1 Like

tx sorry

No worries

Is there a reason that the time zone in App:Logins is using a different time zone than the rest of my sheet? Is it tied to Glide servers’ timezone? Not a huge deal, but if my App:Logins could use my own time zone, it would mean I don’t have to do a conversion on it.

In my experience, the time is pulled from the time zone of the USER not the SHEET/APP OWNER which does present issues when displaying time stamps or sorting by date.

@Mark et. al… how might we account for this issue?