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
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
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (4,621)