We are trying to get a column date into a IF-Else relation column but in vain. In the same table:
- Some Records are HQ records i.e ID is HQ
- Some Records are related to the above HQ as subsidiary
- If HQ has a Contract Start Date, those related Records contract start date will follow.
The above is a lookup on Contract/Subsidiary Follow HQ Contract Start Date
However in the IF-ELse column we are not able to get the above dates
Why is the dates empty when it is showing the rightful?
Thanks for any advise in advance!