Power Platform Community Forum Thread Details

Hello,

I want to add a column that generates the duration in days between the "Recored created on " column and the current date (today()):
column =

DateDiff('Record Created On',UTCToday())

the error Im getting is :This operation cannot be performed on values which are of different Date Time Behaviors.

the Record Created On column is a built in column (not add by me) and it is date only, user local

I tried to edit the table in excel but adding new column is not supported I guess, do you have any idea how to solve this?

Categories:

Add duration column in dataverse table