I am trying to do a simple compare on my report in a text box.
I have the following code in my control source but it is returning #ERROR on my report:
=Iif([WC DATE] < date(), "Date is in the past", "Yeehaw")
do i need #'s or something?
I have the following code in my control source but it is returning #ERROR on my report:
=Iif([WC DATE] < date(), "Date is in the past", "Yeehaw")
do i need #'s or something?
