I have a field that I am trying to “automate” with an expression.
I have two columns, DATE IN and BILLING DATE.
Billing Date needs to compute based on the following:
- Billing Date to be pre-filled from a value in another table, from column “SET BILLING DATE”
- IF the DATE IN is after the value in SET BILLING DATE (from the other table), then it needs to be the value from DATE IN
Any help or steer in the right direction would be much appreciated! Thank you in advanced