So the information regarding dates in collections are a bit unclear so thought id ask a direct question for clarification. (and making it searchable later)
When you perform a wix query on GE/LE/GT/LT on a date object like created by. Does it actually use the timezone correctly to check. Example
let today = New Date();
let Yesterday;
Yesterday.setDate(today.getDate() -1)
wixdata.query('testCollection').eq('_CreatedBy',Yesterday)
(To be clear this is just example code i wrote as asking question it might not be compilable.)
But question remains. Now I run this function in at GMT +2
But a person made the Createdby in PST. Does the query actually calculate the difference correctly using a query on dates, or simply look at Time, Date, Month and Year of what ever was inserted into the collection.