Datetime discrepancy by an hour between Collection and Query

Ask the community
,
1

Hi,

My collection has a date field:

When I query the collection it returns a result that is one hour earlier.

let cardsToSend = await wixData.query('UserCard')
 .distinct('sendDate')

It returns a result that is 11pm of the day before:

0: “2020-05-17T23:00:00.000Z”
1: “2020-05-24T23:00:00.000Z”
2: “2020-05-20T23:00:00.000Z”
3: “2020-05-14T23:00:00.000Z”

This means it is returning the wrong date (I don’t care about the time).

What do I need to do to fix this?

Thanks for any help.

2

In case it is useful to anyone. It’s got something to do with data being used in both UTC and local time. I’ve got around it by moving the time forward 12 hours, so a few hours here or there won’t break anything.