Answered

How to change TimeZone for Datetime column in Powerapps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

mdevaney 29,991 Moderator on at

Like (3)

Report
Copy link

Link copied!
@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."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
RatanKP 39 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
FS-30091336-0 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No