Using the date picker item, if I store a date to MSSQL server, it retrieves it correctly but displays it as the day prior. The correct date is getting set in the SQL server.
Storing: value 2015-01-01T05:00:00.000Z
You can see in the image that it has read the value correctly, but it is displaying it as the prior date. The formatted string field has it as 12/31/2014 not 1/1/2015.
Hmmmm looks like a bug! Thanks & noted – will let you know when we have a fix!
@pdamato @kent Is 2015-01-01 at midnight UTC 2015-12-31 in your timezone by any chance? If you live in any timezone that is a - utc adjustment rather than a +, it would be. I’m pretty sure that the datepicker displays values in the local timezone by default.
Very interesting
Table values also incorrectly show date values. My example is using MSSQL again, but it actually looks like Retool is reading the value correctly and then changing it a little when it shows it on the screen. 
i’m having the same issue. it always appears to change the date to local. A lot of what we do it in UTC so it would great if it didn’t automatically change the date.
@pdamato It looks like the date column type has the same functionality where it parses dates into the local user’s timezone. We’re currently working on adding an option to datetimepickers to disable the conversion, and I’ll open up another ticket for adding that option to date type columns in the table!
Hi @alex-w - thanks for the work on the datetimepickers - great stuff! I just refactored my api/tables to always have timezone to get around the bug you mentioned in post #7, e.g. “I’ll open up another ticket for adding that option to date type columns in the table!” Is there a way to track that issue?
Thanks again!
Dan
Can the same option be extended to these components within a table field data type ?
I'm currently using the "Date" column type for a table, which displays just the 4-byte day representation of a date/time correctly in the table (as shown in the screenshot below).
However, you can see that the newRow query for a date entered is accounting for the current timezone when a date is entered, which means (for me) that the date displayed switches back a day, due to UTC being 10 or 11 hours behind my local timezone.
Is it possible for either:
Hi @gsanders! That’s actually queued up as well to get the same option as the components, so #2! @gilcrest We’ll post back in this same thread with updates on the date column type!
@gsanders We do still need to add this or a similar option to the date column type, but just want to check- have you seen the Date time (original timezone) column type?
@alex-w thanks for the suggestion and apologies for the slow response.
the Date Time (original timezone) isnt a direct replacement for Date for two reasons:
Date type just shows the date without any time (ideal)Following up here - the “use local timezone” selector on datetimepicker components doesn’t work. I have that option unselected and it keeps adding in time zone corrections - please advise. Thank you!
Hey @markbenepass, sorry about this. What do you mean by timezone corrections? Could you send over a screenshot?
Screenshot attached. "Use Local Timezone" is unchecked, the time that's picked defaults to T07:00:00.000Z.
It should default to T00:00:00.000Z
Hey Justin - any updates on this? The “Use Local Timezone” option is still broken, it’s a real pain
Hey @markbenepass! Sorry for missing this. Yep, was just about to reproduce on my end. Will try and get this fixed soon, and will update the thread!
Any updates on this? I choose the Date Time (local timezone) and nothing changes
Would love an update - this is making it really error-prone to use these components. @Justin - please take a look
