Patch to Excel Date field

(0) Share

Report

Posted on by neill_long

728

Hello,

I am trying to patch to a excel spreadsheet and when i try to patch to a field which is set to Date format, it is displaying yesterdays date even though i am saying Today() in the patch:

Patch(Kingsway,
LookUp(Kingsway,ID2 = Gallery1_2.Selected.ID2), {Status: "EMAILED",'Date Emailed': Today()})

Should display 16/05/2024 in excel column, but it displays 15/05/2024.

Is there something i am missing that may be causing this?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-yueyun-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi , @neill_long

The Today() function works with the local time of the current user. So for example it return 2024/5/17 00:00:00 in my side (UTC+8 ) today. When we patch to the Excel Date column, it will convert it to the UTC time in Excel. So when we use the Patch to add a row in excel , it will convert 2024/5/17 00:00:00 (UTC+8) --- > 2024/5/16 16:00:00 (UTC+0).

So you need to use this expression in your app:
Patch(Kingsway,
LookUp(Kingsway,ID2 = Gallery1_2.Selected.ID2), {Status: "EMAILED",'Date Emailed': DateAdd(Today(), -TimeZoneOffset(), TimeUnit.Minutes)})

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No