Datatable : Date Field Displaying -1 Day

[pcarass]

Hi @ericrsmith35 / @alexed1 , I am using the latest version (4.0.3) and also had the same issue with with the previous version (3.5.1). I am pulling in a collection of records from my "Work Order Task" Object. They have a Start and End Date Fields on them, and I have a Text Formula field which is a concatenation of the Tasks fields called "Task Details".

When displaying this collection in the datatable, the date values in the Start and End date fields are out by -1 (minus one) day

And the values shown in the text formula field are displaying the correct values. Any idea why this would be occurring? We are all on GMT timezone, so I don't believe that Locale settings is an issue. Any help would be greatly appreciated. Thanks

[ericrsmith35]

I will try to reproduce this.

[timpino]

We have the same issue in our org

[pcarass]

Hey @ericrsmith35 , Any luck reproducing this issue?

[ericrsmith35]

Not yet 😟

On Fri, May 6, 2022 at 4:03 AM pcarass @.***> wrote:

Hey @ericrsmith35 https://github.com/ericrsmith35 , Any luck reproducing this issue?

— Reply to this email directly, view it on GitHub https://github.com/alexed1/LightningFlowComponents/issues/1108#issuecomment-1119359380, or unsubscribe https://github.com/notifications/unsubscribe-auth/AF4UHXYQXG5I4H3YIADWRTDVITG5DANCNFSM5T7KZO6Q . You are receiving this because you were mentioned.Message ID: @.***>

[pcarass]

No problem @ericrsmith35 👍 I was able to remove the date columns in question and just use the text formula field to represent them, so there's no major panic on it from me 😀

[timpino]

To help you troubleshoot, this issue occurs in an org based in Japan, with users across the globe, strangely it happens to East Asian users, most likely due to their time zone offset

Hope this helps.

When they are entering time/date, it is saved correctly on the record but displays with a date skew

BR

Sent from my iPhone

On 6 May 2022, at 12:40, pcarass @.***> wrote:

 No problem @ericrsmith35 👍 I was able to remove the date columns in question and just use the text formula field to represent them, so there's no major panic on it from me 😀

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.

[eflorespmc]

Bumping this as I'm suddenly having the same issue with dates being shown -1

[frank-vdp]

Getting this in multiple orgs in Australia

[ericrsmith35]

@pcarass @timpino @eflorespmc @frank-vdp I have implemented a bug fix for the Datatable component where dates could sometimes be off by 1 day. This would typically happen when the date being displayed, and the current date had a mismatch with one of them being in Daylight Savings time and the other one was not.

Before publicly publishing this fix, I would like to get feedback from users that had experienced the issue. Please install the current versions of the UnofficialSF Base Packs (https://unofficialsf.com/flow-action-and-screen-component-basepacks/) then install Version 4.0.4 of the Datatable component.

Sandbox (https://test.salesforce.com/packaging/installPackage.apexp?p0=04t5G000003rUxRQAU) Production or Dev (https://login.salesforce.com/packaging/installPackage.apexp?p0=04t5G000003rUxRQAU)

Please let me know if this fixes your issue or if you are still having a problem with dates being off by one day.

Thanks, Eric Smith

[eflorespmc]

@ericrsmith35 confirming that the updates did resolve the issue. Thank you for your speed addressing the issue (on top of everything else you do). 🥇