Answered

Calculated field error

(0) Share

Report

Posted on by sutekh

509

I'm trying to show the difference between two Date fields in my model driven app. I've put in 'DIFFINDAYS' and it worked on other fields but it's throwing that warning/error below. I can't see why because both fields are Date fields? What am I doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

JayMagness 1,663 on at

Like
a
(0)

Report
Copy link

Link copied!

HI,

Here is the formula sample, looks like you have a "_" not a "."

DateDiff(Today(), EndDate)

Jay

Was this reply helpful? Yes No
sutekh 509 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @JayMagness I gave that a go and got the following error. I did try replacing cr1b0_ with crb10. but that didn't make a difference.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @darrenfloyd666 ,

The error means that the DIFFINDAYS() returns the integer type value (number), which is not compatible with Baseline Duration field(Date Time type).

You have to create a new Baseline Duration field of whole number type.

Hope this helps.
Sik

Was this reply helpful? Yes No