Recent content by cyoung

Thanks Bob, you're right I do need to account for those situations where the received date = to effective date. Also, I tried that statement, but now get Data mismatch expression error. Any thoughts?

Hi, I'm hoping someone can help me. I'm trying to do an IF Then statement on dates. So if the Date received is before the effective date, Yes and if not, No. I can't get it to work. The Received date has been converted to a text format. Originally it looked like this: 20110518, but I have a...