159
I have a data connection to an external data and receive a column in this text format 02/13/2024 20:15:00. Unfortunately the field is text formatted.
I need to make some calculation with this text. I believe first i need to convert to date time format and then I need to calculate the difference between Now() and this column measure in hours.
Can anybody help me with a solution?
Thank you
You should be able to use the DateTimeValue function to convert to a date DateValue, TimeValue, and DateTimeValue functions - Power Platform | Microsoft Learn
And then DateDiff to find the difference
DateAdd, DateDiff, and TimeZoneOffset functions - Power Platform | Microsoft Learn
-------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Share
Report
All responses (
Answers (
