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

Date picker time is an hour off?

Hello,

 

I'm using a datepicker on a form and when I enter a time, say 8 AM, it's submitted into the SQL database as 7AM. It's always 1 hour off.

 

If i change the time to 9AM it will be entered as 8AM etc. The datepicker is set to local time.

 

Has anyone run into this issue?

 

thanks

2 REPLIES 2
TomVine
Frequent Visitor

Assume this is because of differences in timezones - have you tried date time zone as UTC?

What code are you use to patch the SQL table?

Thank you for your response.

 

I'm not using a patch for the submit. I using a form submit to insert directly into the table. The SQL field is a datetimeoffset because i've read that the normal datetime field is not great for filtering against. 

 

 

 

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,988)