Forum Discussion

Nicktrom55's avatar
Nicktrom55
Copper Contributor
Oct 13, 2023
Solved

Issue with Excel Formula for Date Range format

I have a power automate that is use to upload a UTC to my excel table. This is used to track when an invoice is received if the invoice is not received within the certain date it reads true and nothi...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 13, 2023

    Nicktrom55 

    Such formula

    returns the text, not date. To convert into actual date just add +0 at the end of the formula or warp it by DATEVALUE().

    As variant on Power Automate site convert datetime zone into date like

    formatDateTime(body()?['Date'], 'yyyy-MM-dd')

Nicktrom55's avatar
Nicktrom55
Copper Contributor
Oct 14, 2023
I fixed it on the power automate side. thank you so much for the help with this. truly appreciated!

Resources