2 entities, 1 sub-entity
Entity A (parent)
- sub entity B (child)
Entity C (parent)
Sub-entity B and Entity C are related using a common field
"Order date" is in Entity A
"Arrival date" is in Entity C
I want to check the difference in weeks between the Order Date and the Arrival date
Code: Select all
({function}-[ID])/86400/7
Is there another way of doing this?
Thanks!