Please Share your Product Ideas with us!

This function fails when we have bad data in the JDE Date field.

Could this be corrected to return NULL in all cases when a date is not valid?

Our solution to this issue is to change dsw.dbo.BOAJDEDate(Field) to dsw.dbo.BOAJDEDate(iif(field<100,Null,field)

(NOTE: This doesn't solve the 99999999 issue, but we haven't encountered the problem with a 'too large' number yet)

Thanks,
Tom

Select dsw.dbo.boajdedate(-1)
Select dsw.dbo.boajdedate(0)
Select dsw.dbo.boajdedate(5)
Select dsw.dbo.boajdedate(9999999)