cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chunkit
Frequent Visitor

Timing Error

Timing Error.PNG

 

 

I am getting date from a sharepoint list, and date come always wrong ( 1 day less than in my sharepoint list).


Please advise.

2 REPLIES 2
v-micsh-msft
Community Support
Community Support

Hi @Chunkit,

 

 

This is a known issue, see this thread:

Date displayed is one day off

Please help with UTC

Please consider take use of the DateAdd function in the text property to correct the date difference:

DateAdd(Thisitem.Date, -1)

Changing the time zone with the Text function seems not working.

Another workaround should be: Format the Date value in Text first, and then use datetimevalue function to get back the date.

DateTimeValue(Text(Thisitem.Date, "yyyy-mm-dd")&"T00:00:00.000Z"))

See if it would work.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-micsh-msft
Community Support
Community Support

Hi @Chunkit,

Do you need any further assistance on this topic?

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (51,354)