List Formatting - Different dates are returned by the getDate operator depending on the time zone of the computer

[tecchan1107]

Target SharePoint environment

SharePoint Online

What SharePoint development model, framework, SDK or API is this about?

Declarative list formatting

Developer environment

Windows

What browser(s) / client(s) have you tested

• [ ] 💥 Internet Explorer
• [X] 💥 Microsoft Edge
• [X] 💥 Google Chrome
• [ ] 💥 FireFox
• [ ] 💥 Safari
• [ ] mobile (iOS/iPadOS)
• [ ] mobile (Android)
• [ ] not applicable
• [ ] other (enter in the "Additional environment details" area below)

Additional environment details

No response

Describe the bug / error

I have observed that changing the time zone of the computer changes the value retrieved by the getDate operator and also retrieves a different value than the date in the date column.

Related Document: Formatting syntax reference

Steps to reproduce

Setting up a list for verification

1. Create a date column with the internal name Date in the list
2. Set any date in the column created in step 1
3. Create a column to display the values retrieved by the getDate operator
4. Set the following JSON to the column formatting created in step 3

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=getDate([$Date])"
}

Change computer time zone

1. Change computer time zone from UTC+09:00 to UTC-09:00

2. When the list is reopened, the value obtained with the getDate operator is not the same as before the time zone change, and is different from the date in the date column

Expected behavior

The getDate operator returns the date of the referencing date sequence without being affected by the computer's time zone.

[tecchan1107]

For reference, I also send a screenshot of the time zone setting for the site.

[Amey-MSFT]

Hello @tecchan1107, Thank you for bringing this issue to our attention. Could you please confirm if the issue still persists for you? We will look into it and get back to you shortly.

[tecchan1107]

@Amey-MSFT

Could you please confirm if the issue still persists for you?

Yes, the issue is still happening.

[Amey-MSFT]

Hello @tecchan1107 We were able to reproduce the issue, and we are investigating it. We have logged this as a bug, and our engineering team will look into it. Thank you!

[Ashlesha-MSFT]

Hi @tecchan1107, Thank you for sharing the details about the date issue with the getDate operator. I have tried to reproduce the behavior by changing both the computer and site time zones to UTC+9, but I wasn’t able to observe the issue on my end.

Could you please confirm if you are still able to reproduce this issue consistently? Also, do you think any page refresh or caching might be affecting the results when testing?

[tecchan1107]

Hi @Ashlesha-MSFT .

Could you please confirm if you are still able to reproduce this issue consistently?

This issue could still be reproduced.

Below are the steps to reproduce the issue.

Reproduction Steps

1. Set the site's time zone to UTC+09:00

2. Set the local PC's time zone to UTC+09:00

3. Create a list

4. Create a Date column with the internal name Date

5. Create items

6. Create a column for formatting and set the following JSON:

   {
     "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
     "elmType": "div",
     "txtContent": "=getDate([$Date])"
   }
   

7. Set the local PC's time zone to UTC-10:00

8. Check the list

Also, do you think any page refresh or caching might be affecting the results when testing?

I don't think they're having any effect.