Answered

How to change TimeZone for Datetime column in Powerapps

Like (0) Share

Report

Posted on 8 Sep 2020 11:57:11 by Community Power Pla...

I am displaying data from SQL server table in powerapps using Gallery. In Sql Server Table, CREATED_DATE column having UTC Timezone.

When I am showing this column in Powerapps Gallery:

But, I need to show the Created Date in Local TimeZone or IST in Powerapps.

Can anyone tell me how to solve this timezone Issue in Poweraps.

Categories:

Using Apps Using Formulas

All responses (5)

Answers (2)

Fizuli 2 on 15 Jun 2023 at 19:50:44

Like (0)

Report

Re: How to change TimeZone for Datetime column in Powerapps

Hi Dear Team.

How can I use TimeZone Offset upon adding days to the date? Where should I put the timezone offset in the example below?
DateAdd(Today(), 115, TimeUnit.Days).

Thanks very..
RatanKP 39 on 24 Jan 2023 at 08:54:42

Like (0)

Report

Re: How to change TimeZone for Datetime column in Powerapps

Hi Team,

Am facing a serious problem with DateValue('Textinput_TimeIN'.Text), as per my SQL Table the Data is in "YYYY-MM-DD" format and when I fetch the data from SQL to Powerapps am receiving the Values as "MM/DD/YYYY"(may be due to SQL Server System Date configuration) and I used Text function to convert to "YYYY/MM/DD" and when am passing the value to date field I got text Conversion error and I used DateValue to convert Text to Date Format and system is converting the DateFormat automatically to "MM/DD/YYYY", I want to convert the Text to DateFormat in "YYYY/MM/DD" Format, any Suggestions would be appreciated.

Thank you in advance for all.
Verified answer

v-bofeng-msft on 12 Oct 2020 at 03:28:08

Like (0)

Report
Re: How to change TimeZone for Datetime column in Powerapps

Hi @Anonymous :

Do you want to convert UCT time to local time?

If so,please try this code:

DateAdd(CREATED_DATE, -TimeZoneOffset(), Minutes)

The TimeZoneOffset() function gives the value of UCT time minus local time, so its plural should be used when converting.

Best Regards,

Bof
Community Power Pla... on 09 Sep 2020 at 04:26:27

Like (0)

Report

Re: How to change TimeZone for Datetime column in Powerapps

I Created the above record on 9/9/2020 09:46 AM. (IST)
But according to DateAdd(ThisItem.CREATED_DATE, TimeZoneOffset(ThisItem.CREATED_DATE), Minutes), I am getting the Date as 9/8/2020 10:46 PM

It would be helpful if you solve this error.
Verified answer

mdevaney 29,987 Super User 2025 Season 1 on 08 Sep 2020 at 12:16:30

Like (3)

Report
Re: How to change TimeZone for Datetime column in Powerapps

@Anonymous
Hello there. To convert your UTC datetime to the local time zone use this code in the Text property of your label.

DateAdd(CREATED_DATE, TimeZoneOffset(CREATED_DATE), Minutes)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."