User friendly queries may show incorrect dates when crossing daylight savings boundary

Description

The user-friendly query will show the date before the query’s real date if the following circumstances are met:

  • The current date is outside daylight savings

  • The query date is inside daylight savings

Steps to reproduce:

  1. Have the current date be outside daylight savings (for example, Nov 12)

  2. Create a query using a date inside daylight savings (for example, Oct 5)

Expected behavior:

User friendly query displays the queried date (e.g. 2024-10-05 or equivalent)

Actual behavior:

User friendly query displays a date immediately before the queried date (2024-10-04)

 

 

We will also use this ticket to display this date in use MM/DD/YY (or other locale-appropriate format).

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

7

Checklist

hide

Activity

Show:

Emma_HaroyanDecember 3, 2024 at 6:28 AM

Tested on Ramsons BF

Works as expected for now.

There is a separate ticket for improvements

JenkinsNotificationsNovember 27, 2024 at 10:52 AM

Deployed to the Ramsons bf env. Moved status to In bugfix review from status Awaiting deployment. Please proceed with the verification.

Noah OvercashNovember 25, 2024 at 12:41 PM

UIPQB-155

Emma_HaroyanNovember 25, 2024 at 6:39 AM

Thanks do we have a ticket for that, or we need to create?

Noah OvercashNovember 24, 2024 at 4:33 PM

that is OK - the query builder/picker should show in the tenant timezone, however, the result set (both for the query testing and the main list contents view) should show in your user’s timezone. We are going to add a message to warn the user accordingly when this happens, but that’s a separate ticket

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Corsair

Fix versions

Release

Ramsons (R2 2024) Bug Fix

RCA Group

Implementation coding issue

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created November 12, 2024 at 3:17 PM
Updated December 3, 2024 at 6:28 AM
Resolved November 25, 2024 at 1:53 PM
TestRail: Cases
TestRail: Runs