Forum Discussion

debarbanson's avatar
debarbanson
Regular Visitor
4 years ago

Fix UTC issue with date field

Dear all,   I am struggling quite a bit with the following. Have googled a lot, read many potential solutions but fail to get it to work. Scenario: We are running a Power App where the date/time ...
Need Help
Tips and Tricks
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

When you first bring in your data, convert that column to datetimezone (not datetime), and then you can use the expression below to remove the zone component prior to extracting the date.

 

Date.From(DateTimeZone.RemoveZone([InputDT]))

 

 

Pat

  • debarbanson's avatar
    debarbanson
    Regular Visitor
    4 years ago

    Hi Pat, many thanks for your reply.
    Followed your steps, however when I change the field into Date/Time/Timezone it still shows 31-1-2022:

    and then after your code:

    Beginning to think there might be something wrong with my timezone? Would have expected that after the change to date/time/timezone it would have shown 1-2-2022 00:00:00 +01.00. Any suggestions?