Unanswered

Date picker show incorrect date ( date retrieved from SQL server DB)

(0) Share

Report

Posted on by tnguyen56

I used date Picker in PowerApp, save the selected date into SQL Sever database. The date value appeared to save into database correctly. However, when I retrieved that date back out to an power app form, it always show 1 day less than the value saved in database. For example, I picked and saved 6/6/2019, when retrieve that value, it show 6/5/2019. I used SQL server database backend.

Any suggestion?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@tnguyen56

You will need to convert this from UTC to get the correct date.

When you store your date in SQL it is stored in UTC values. In order to get the correct date, you will need to apply the TimeZoneOffset function to it in order to adjust for your timezone time.

To verify this, you can try to take a look at one of your dates and include the time - Text(yourSqlDate, "dd/mm/yyy hh:mm") - and you will most likely see that the time part is the issue. If you are in a timezone that is negative UTC, then it will subtract that amount from the date of 6/6/2019 00:00. So, if you are in -5 hour timezone, then 6/6/2019 00:00 becomes 6/5/2019 19:00 - and thus the day before you expect.

I hope that is clear and helpful for you.

Was this reply helpful? Yes No
tnguyen56 8 on at

Like (0)

Report

Thank you.
It worked when I used TimeZoneOffset that you suggested

Was this reply helpful? Yes No
tnguyen56 8 on at

Like (1)

Report

Thank you.
It worked when I used TimeZoneOffset that you suggested

Was this reply helpful? Yes No