Dates misalignements in extracted tables

  • 24Views
  • Last Post 13 February 2023
0
votes
Sergio Sardo posted this 07 February 2023

In many tables (example: the "Bugs" table) the same date is shown in two different formats, the am/pm one and the "Timestamp" one, but they shows different values, shifted 1 hour.

 

The right date/time from ZohoProject is the one in am/pm format.
 I attach a sample of what I see.

SkyVia query, with the two dates columns highlighted

Order By: Standard | Newest | Votes
0
votes
Yevheniia Bilotserkovska posted this 10 February 2023

Hello Sergio.

Thank you for contacting us.

We are investigating the case and will return with feedback ASAP.

Best regards,

Yevheniia Bilotserkovska.

0
votes
Yevheniia Bilotserkovska posted this 13 February 2023

Hello Sergio.

Thank you for your waiting.

Skyvia works with Zoho Projects via their API and it is bounded by API's features and limitations.

According to API, DueDateFormat is a string column, and DueDateLong is a date. Zoho Projects sends this date in the UnixTimestamp format (for example - 1667541182000), and Skyvia converts it to human readable, and displays the date in GMT (or UTC) , without converting it to the user's time zone (since we don't know it). In other words, Skyvia displays data in the same way as it is coming from API.

Please find the example below:

If you need any additional information from our side please let us know.

 

Best regards,

Yevheniia Bilotserkovska.

New Ticket
Categories
Popular Tags
Close