Problem detecting BST saving for date held in Collection

Ask the community
,
1

Summary
When dates are held in a collection, reading of those dates shows BST daylight saving applied to those dates, silently, giving the impression that dates entered are incorrect.

Recreate

  1. Create a collection containing a Date Time column and populate with dates and time throughout the year.

  2. Extract those dates within javascript and (at least UK coders) will see that times within BST daylight saving have silently been reduced by 1 hour, even though when those dates are viewed within the database editor, they are not shifted.

getTimezoneOffset() is always set to 0 so there is no way, that I can find, to detect that BST daylight saving has been applied to particular rows.

Workaround
The work around is to write some ugly JS to manually detect if the date in question is within 25 March to 28 October and reset those dates’ times to the values entered.

How Wix can improve matters.
Do not manipulate dates silently when they are extracted from a Collection.

2

The Date object in Wix Code is just a plain old vanilla Javascript Date object. For more information, you can review this article about Javascript Dates .

I hope this helps.

Yisrael