Try to add ''
if [Aeendt] +'.' then'Ongoing' else 'Completed' end
Thanks for your response! I tried using '.' instead, but this did not work. I got an error message that says "Can't compare date and string values." Please let me know if this sheds any more light on the issue.
how about if you try converting it to a string first? Try this out -->
IF str([Aeenddt]) = '.' then 'Ongoing'
Thank you for your response! This worked and got rid of the error message I was getting.