I have 2 formulas in a sub-report.One gives me the number of days since a patients last appt. and one displays "NO APPT. DATA ON FILE" if {billing_tx_history.date_of_service} is Null. How can I combine the 2? The formulas are as follows
1) Numbervar Days;
Days := DateDiff ("d",{billing_tx_history.date_of_service}, CurrentDate);
2) IF ISNULL ({billing_tx_history.date_of_service})
THEN "NO APPT DATA ON FILE"
I am running this on CR XI
1) Numbervar Days;
Days := DateDiff ("d",{billing_tx_history.date_of_service}, CurrentDate);
2) IF ISNULL ({billing_tx_history.date_of_service})
THEN "NO APPT DATA ON FILE"
I am running this on CR XI