cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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
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
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

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.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

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 (8,188)