evidence-dev / evidence

Business intelligence as code: build fast, interactive data visualizations in SQL and markdown
https://evidence.dev
MIT License
4.49k stars 216 forks source link

[Bug]: Wrong dates in DateRange #2724

Open igorgukasyan opened 3 weeks ago

igorgukasyan commented 3 weeks ago

Describe the bug

Latest merge seems to have made date ranges from DateRange (maybe not only) work incorrectly - the dates in inputs.source.start and inputs.source.end are one day earlier than what they were set as.

Thanks!

Steps to Reproduce

  1. Go to https://docs.evidence.dev/components/date-range#filtering-a-query under "Filtering a query"
  2. Set dates
  3. Check their correctness

I could also replicate it in my own dashboard

Logs

No response

System Info

No response

Severity

serious, but I can work around it

Additional Information, or Workarounds

No response

archiewood commented 2 weeks ago

Hi Igor - this change was implemented in https://github.com/evidence-dev/evidence/pull/2694

Can you confirm what time zone you are in, perhaps this is having an impact

igorgukasyan commented 2 weeks ago

Hi Archie,

I am in CET, thanks!

archiewood commented 2 weeks ago

Suspect this is impacting all users accessing Evidence from UTC+XX time zones.