Date from database are being reduced by 1 day when putting into textbox.
eg.
Database:
06/01/2019 00:00
when being output on
let myDate= event.rowData[“myDate”]
$w(“#InputUpdateMyDate”).value = myDate;
2019-05-31T20:00:00.000Z
No reply from Wix and I’m having the same issue. What a wonderfully thoughtful professional company
Try this, not sure it will work though… Changing Your Site's Regional Settings | Help Center | Wix.com
Hello! It seems that this might be due to a difference in time zones. The server operates in UTC, but on the database, the date is displayed according to your local time zone. Therefore, if you generate text without considering the time zone, the resulting date text may differ from what you expected.
I do not believe it has anything to do with time zones. Wix acknowledged there was a bug and that they were working on it.
It was reported yet again in February that a different date would appear when it was connected differently.
1 Like
I didn’t know there was such a bug…! Thank you, Code Queen!
1 Like
Guys, this’s been happened like over 5 years 
please fix, instead of simply linking CMS to table, i have to code my table in pain 