Skip navigation
Contact Us
7864 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?

Hi,


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


is_date(input_date,'DD-MON-YYYY').


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.


Thanks,

Kamalakar

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

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