Date Value Comparison

Good day,

I am receiving garbage data from my other department as follows.

I want:

'12/05/03' for example.

I get:

'//'
'00/00/00'

And other garbage. All of which crashes the transaction because it cannot be converted to Datetime.

What I would like to do is something like this:

IF @v_date > '01/01/50'
BEGIN <-- statement will crash if bad data)

Something to trigger a Boolean (True/False) validation of the data.

I want to know if it is even a date before I run it through my block.

Any thoughts?

I don't want to add a new IF block for every bizarre thing they send me.

Thanks ahead of time.


PS - I guess I could just raise an exception and handle it in a block that way, but am still curious.