52
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,263
Super User 2024 Season 2
#2
Martin Dráb
228,112
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
