Timezone issue with GROK now() function when filtering by datetime in Sanity editor

Another thing that I've noticed is that when I set a datetime in the editor and then try to filter using GROK now() function, there seems to be a 1-hour timezone difference:

*[_type == 'quiz' && publicationDate <= now()]

For example, having set 8 am in the datepicker, the request will only return a result at 9 am. The date I get in the document is correct though so I think the issue is with the

now()

function

What UTC time are you seeing in the

publicationDate

data for the relevant document? If you consider

now()

is UTC, does that correspond to the results?

the

publicationDate

is a ISO8601 string and is correct according to my timezone:

2020-08-11T06:00:00.000Z

(I'm in Paris, UTC+2). So even with

now()

being UTC the results don't make sense

Agreed, that doesn’t make sense. Are you getting any different results if you wrap both

publicationDate

and

now()

in

dateTime()

? As follows:

That works, thanks!

Awesome, glad to hear!