Forum Discussion

jtownsend21's avatar
jtownsend21
Icon for Responsive Resident rankResponsive Resident
7 years ago
Solved

Relative Date Function - IF Past do 'X', IF Present do 'Y'

I have 2 tables that contain revenue information. Revenue Actual - reported revenue for past months.  Sample Data:  Office Period Revenue 1 1/1/2019 55000 1 2/1/2019 70000 ...