I have a text field that I would like to convert to a date to provide consistent formatting as a sort field. I know how to convert the text to a date format; however, when doing so the expression sometimes results in an error (when the text being converted isn't actually a date).

What is Crystal Reports version of "iserror"? I would like to have it check to see if the expression will result in an error, and if so return "true" or "false" or even, to save me a step, a default value. Any suggestions?


Edited by AlyssInABubble - 12 Sep 2012 at 8:32am

IsDate works great! Thank you!