Skip to content

Displayed date & filtered input appear to be in different timezones #2894

@jdangerx

Description

@jdangerx

Bug Report

Steps to Reproduce:

  1. Check out my repro repository.
  2. It seemed a little bit silly to make a whole new repository from last time (Filtering float columns leads to "invalid scalar" error #2881) so I just made a branch called dates - check out that branch. Or tell me to make a new repository.
  3. npm install && npm run start
  4. Try to filter on date == 12/31/2024 and date == 01/01/2025, see that the left and right sides don't appear to match.

Expected Result:

I expected either:

  • filtering on date == 12/31/2024 shows one row, date == 01/01/2025 shows 0 rows, displayed date is 12/31/2024 (i.e., the displayed date & the user-input date are both in local time)
  • filtering on date == 12/31/2024 shows no rows, date == 01/01/2025 shows 1 row, and the displayed date is 01/01/2025 instead of 12/31/2024 (i.e, the displayed date & the user-input date are both in UTC)

Actual Result:

Filtering on date == 12/31/2024 shows no rows, date == 01/01/2025 shows 1 row, and the displayed date is 12/31/2024

  • OS and version
  • Platform/language + version

Environment:

For JavaScript (browser):

  • @finos/perspective version: 3.2.1 - I see there's 3.3.0 out now (maybe in the process of creating a release? perspective-esbuild-plugin doesn't have 3.3.0 yet)
  • Browser and version: Version 131.0.6778.265 (Official Build) (arm64)
  • OS: macOS 14.4.1 (23E224)

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugConcrete, reproducible bugs

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions