Your date fields should be field type of Date. If the date field is not of type date then the calculation will be wrong.
interesting. so, what about a combining the Month, Day, and Year fields in a cDate field; and:
If ( Lookup ( cWOM ; WarrantyCal_VendorName::cDate ) > Get ( CurrentDate ) ; "IW" ; "OOW")
Would it be any different? I'll try it and see how it goes. appreciate your reply.
schamblee, i cannot thank you enough...it was right there in front me and i can't believe this brain fart of mine. omg, i hate myself for not seeing it. i do appreciate and thank you very much for your answer. by changing the field type to Date solved this problem.