cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sumitmukund
Level: Powered On

Storing Datetime from PowerApps to SQL

Hi,

 

We have a datepicker control which is mapped to a datetime column in SQL server(we are only storing the date portion of the picker control). The TimeZone property of the datepicker control is set to UTC. When we  select a date in the control and try to save it in DB it saves it as one day less,for ex 16/10/2019 is saved as 15/10/2019 . Tried few of the tricks with TimeZoneOffset but no luck.

 

Much appreciated for any help!

 

Thanks

ThreeAtion

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft v-siky-msft
Microsoft

Re: Storing Datetime from PowerApps to SQL

Hi @sumitmukund ,

Could you share more design intent about app?  Why do you need to set TimeZone of Datepick to UTC?

What is TimeZone of your SQLserver? What is your local TimeZone?

 

Since TimeZone of Datepick is set to UTC and SQL DB is local, so during the save process, the date you select will be converted from UTC to local, and then the converted date will be stored to SQL DB, causing the time deviation. 

So could you try to post back your TimeZone details?  You also can use Text() function to format your date to show Hour and Minute, and check if there is a time difference between them.

Text(DateValue1.SelectedDate,DateTimeFormat.LongDateTime24

Best regards,

Sik

View solution in original post

1 REPLY 1
Highlighted
Microsoft v-siky-msft
Microsoft

Re: Storing Datetime from PowerApps to SQL

Hi @sumitmukund ,

Could you share more design intent about app?  Why do you need to set TimeZone of Datepick to UTC?

What is TimeZone of your SQLserver? What is your local TimeZone?

 

Since TimeZone of Datepick is set to UTC and SQL DB is local, so during the save process, the date you select will be converted from UTC to local, and then the converted date will be stored to SQL DB, causing the time deviation. 

So could you try to post back your TimeZone details?  You also can use Text() function to format your date to show Hour and Minute, and check if there is a time difference between them.

Text(DateValue1.SelectedDate,DateTimeFormat.LongDateTime24

Best regards,

Sik

View solution in original post

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (7,192)