DSXchange

Hello Friends
I am trying to load data from a flat file into a teradata table. I have some date values in my flat file like
RECEIPT_DT = 20070623000000
Which i am loading in a date type filed of teradata. I am using the modify stage for the conversion but its giving me an error. I am putting the value as follows in my modify stage

RECEIPT_DT:Date=date_from_string["%mm/%dd/%yyyy %hh%nn%ss"](RECEIPT_DT).
Can you please help me in letting me know the problem.

Thanks

Teradata timestamp format is

2007-10-26 17:08:48

So try

RECEIPT_DT:Date=date_from_string["%yyyy-%mm-%dd %hh%nn%ss"](RECEIPT_DT).