cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

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
Community Support
Community Support

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
Community Support
Community Support

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
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (4,375)