Date Difference Formula Dataverse for teams

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

I know this is a simple one but just can't hit on the right syntax !🙄

Dataverse for teams columns. Trying to calculate DateDiff (answer in days) from a date in the past (StartDate) and another one for a date in the future (FinishDate)

DateDiff( UTCToday(),'FinishDate')

This operation cannot be performed on values which are of different Date Time Behaviors. and it says no quick fixes available..

TIA

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Any suggestions? I know the formula type is in preview but I can't seem to find any other way to do a calculated column now?

Was this reply helpful? Yes No
Verified answer

vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I just created a separate date column which I put the default as todays date and then just used the datediff function which worked between 2 fields just not if I was trying to use Today or Now

Was this reply helpful? Yes No