Calculating the difference between dates from two different tables

(0) Share

Report

Posted on by CalebG

I'm currently trying to make a view of orders that also includes the quote created on date. The only columns I have right now are Order ID, Name, Created On (Quote), and Date Fulfilled. However, I want another column that displays the difference in days between the two dates but I am having difficulty with this because they're from two different tables. Does anyone know if there is a way I can achieve this?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

I was able to implement such functionality but it was a bit hacky.

1. On your child entity (Order) create a "Calculated" field to bring the data from (Quote) to the level of Order - it's a classic Calculated field. Check this - dyn365pros.com/.../

2. In order to "Consume" the data from that newly introduced field and get the difference between dates you will have to use new "Formula" field - learn.microsoft.com/.../formula-columns

Good luck.

Was this reply helpful? Yes No