DSXchange

Hi,
I need to convert incoming String to Date. The format of the string is "Month dd, yyyy" Ex: (November 29, 2012).

I used below function and job got aborted with error " Invalid type: November 29, 2012."

StringToDate(Input Column,"%mmmm %dd, %yyyy").

Please help on this.

The issue was with IsValid function. Ran to success after making below change

Before:
IF
IsValid(Source, "%mmmm %dd, %yyyy")
THEN
StringToDate(Source,"%mmmm %dd, %yyyy") ELSE SetNull()

After:
IF
IsValid("date",Source, "%mmmm %dd, %yyyy")
THEN
StringToDate(Source,"%mmmm %dd, %yyyy") ELSE SetNull()

Right. You need to tell it what kind of validation it needs to do. And don't fall into the trap of thinking you can use IsValidDate instead.