IS_DATE - Check for Valid Date in Informatica

IS_DATE function checks whether the input date is valid date.
Syntax
IS_DATE( value or port,[format] )

Example : Check the input date is valid or not, no format specified
IS_DATE( INVOICE_DATE )

INVOICE_DATERETURN VALUE
NULLNULL
1800 (FALSE)
'04/01/98'0 (FALSE)
'04/01/1998 00:12:15'1 (TRUE)
'02/31/1998 12:13:55'0 (FALSE) (February does not have 31 days)
'John Smith'0 (FALSE)


Note : If you have date in string format, you have to apply TO_DATE before apply IS_DATE check