Invalid Format - Date

harryhome · Post by **harryhome** » Fri Feb 11, 2011 8:07 am

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

DSguru2B · Post by **DSguru2B** » Fri Feb 11, 2011 8:33 am

Try searching here. Its been covered a lot.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 11, 2011 1:50 pm

Look very carefully at the percent signs in the error message.

ds_sai · Post by **ds_sai** » Sun Feb 13, 2011 9:11 pm

Try this....
StringToDate(DSLink3.Testdate,"%yyyy-%mm-%dd")

ray.wurlod · Post by **ray.wurlod** » Sun Feb 13, 2011 9:28 pm

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.