Page 1 of 1

Invalid Format - Date

Posted: Fri Feb 11, 2011 8:07 am
by harryhome
Hi,

In transformer trying to check a condition on date in IF condition as below

Date_column_input = StringToDate('1999-12-31',"yyyy-mm-dd")

and getting below error:


APT_CombinedOperatorController,0: Operator terminated abnormally: Terminating with exception:APT_ParseError: Parsing parameters "yyyy-mm-dd" for conversion "date=date_from_string[%yyyy-%mm-%dd](string)": APT_Conversion_String_Date: Invalid Format [yyyy-mm-dd] used for string_from_date type conversion

Posted: Fri Feb 11, 2011 8:33 am
by DSguru2B
Try searching here. Its been covered a lot.

Posted: Fri Feb 11, 2011 1:50 pm
by ray.wurlod
:idea:
Look very carefully at the percent signs in the error message.

Posted: Sun Feb 13, 2011 9:11 pm
by ds_sai
Try this....
StringToDate(DSLink3.Testdate,"%yyyy-%mm-%dd")

Posted: Sun Feb 13, 2011 9:28 pm
by ray.wurlod
ds_sai wrote:Try this....
StringToDate(DSLink3.Testdate,"%yyyy-%mm-%dd")
If you give a man a fish, he's not hungry for a little while and is then hungry again. If you teach a man to fish, he need never be hungry again.