Skip navigation
Contact Us
15653 Views 6 Replies Latest reply: Oct 12, 2010 9:12 AM by KAMALAKAR VADDI RSS
KAMALAKAR VADDI Newbie 13 posts since
Sep 3, 2010
Currently Being Moderated

Oct 4, 2010 1:34 PM

How to validate date format using Is_date function in Informatica?


I have a date column coming from source table. Challenge is to validate the date whether it is in right format.

Example Values of source column:

22-AUG-2010  --> Valid date/format as per business rule

22 AUG 2010  --> InValid date/format as per business rule

22/AUG/201   ---> Invalid date/format as per business rule

I have used is_date function in expression as below :i


Surprisingly all the above three example values have returned output as 1 saying all are valid dates even though i have specified format as 'DD-MON-YYYY'.ats

Could anyone please help me to restrict invalid date formats.

Appreciate your help in advance.



More Like This

  • Retrieving data ...

Bookmarked By (0)


  • Correct Answers - 10 points
  • Helpful Answers - 5 points