lookit/lookit-api

Incorrect time conversion from UTC to EST

sradifera opened this issue · 4 comments

Screenshot 2024-03-13 at 1 52 29 PM
Screenshot 2024-03-13 at 1 52 35 PM
Screenshot 2024-03-13 at 1 53 17 PM

When reviewing spam reports I need to view the consent video of the participant in question. The researcher who makes the report provides the date created of the consent video which to my understanding is in UTC. To find and review the consent video on my end I need to convert this time into EST since I am in Cambridge, MA. In the example I show int he screenshots, the conversion is an hour (and a day?) off than what google tells me is the correct conversion from UTC to EST. Not sure if this is a problem with my machine (macOS) or the site.

@sradifera

Could you provide the experiment that this example was pulled from?

@sradifera

To confirm that the date/time was correctly converted from UTC to EST I used a browser's Javascript console. Instantiating a Date object with the UTC string from the "Data Sessions" card provides an EST date/time that matches what has been selected in the "Responses" card.

Screenshot 2024-04-16 at 9 27 38 AM Screenshot 2024-04-16 at 9 31 43 AM Screenshot 2024-04-16 at 9 31 24 AM

@okaycj Thank you for the help! This issue should be resolved now.