Can you use Date fields in a calculation in a Model Driven App?

(0) Share

Report

Posted on by sutekh

509

Afternoon

I have two date field in my entity - baseline start and baseline finish - and I want to show the duration in a third field - as seen below. I thought it would be a simple case of A - B but I'm getting the error below. Anyone got a workaround? All help gratefully received!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Hi @darrenfloyd666

You were close and it is simple. In the calculation use the DIFFINDAYS(StartDate,FinishDate) function.

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report
Hi @darrenfloyd666 ,

Do you want to create a Calculated field in your Entity with date difference value from baseline start and baseline finish?

Based on the formula/expression that you mentioned, I think there is something wrong with it. Currently, within CDS Entity, the '-' operator could not be used to calculate the difference between two different date time values.

As an fixed solution, please take a try with the following workaround:

Action Formula Box set to following:

DIFFINDAYS(createdon, crba2_duedate)

On your side, you should type following:

DIFFINDAYS(cr1b0_baselinestart, cr1b0_baselinefinish)

Note: Above formula would calculate the Duration in Days Unit. If you want to calculate the Duration in other units, Hours, Minutes, Weeks, ..., please try the following function:

DIFFINHOURS(cr1b0_baselinestart, cr1b0_baselinefinish)
DIFFINMINUTES(cr1b0_baselinestart, cr1b0_baselinefinish)
DIFFINWEEKS(cr1b0_baselinestart, cr1b0_baselinefinish)

...

...

Note: There would have formula intelligence prompt in above Action Formula box when you type some key word, e.g. 'DIFF'

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
sutekh 509 on at

Like (0)

Report

Thanks, I'll give that a go

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

Hi @darrenfloyd666 ,

Sure. If the solution I provided above is helpful in your scenario, please consider go ahead to click "Accept as Solution" to identify my reply as helpful.

Best regards,

Was this reply helpful? Yes No