DSXchange

Just wanted to share a solution. Input: YEAR=2011 (YYYY) MONTH=2/02 (M/MM) Output: Date 2011-02-28 Code: StgMonth If MONTH EQ 12 Then StringToDate(YEAR+1: "-" :"01": "-" :"01","%yyyy-%mm-%dd") ELSE StringToDate(YEAR: "-" :Right('00': ( MONT...

Try this.

StringToDate(Col,"%yyyy%mm%dd").Remove (-) inside the function.

By the way what is your target. Database or File.?

StringToDate(Column,"%yyyy-%mm-%dd")

try using bigint

What is your input data type

I just did a test it works fine i used this data input- 03/13/2010 .. output comes as 2010/03/13 use input datatype as (varchar) -10 in the transformer use this code StringToDate(DSLink3.DATE,"%mm/%dd/%yyyy") Output datatype ( DATE) go to columns tab (output stage) and edit column meta dat...

what is your input ? database/file

what is the datatype.?

i just tested a job it works fine

sorry i forgot these % in the code

try this in the derivation

StringToDate(input,"%mm/%dd/%yyyy")

and do the same in the output as i mentioned in the other reply

please post the error.

try input using varchar(10) and output as date derivation : StringToDate(input,"%mm/dd/yyyy%") If you have nulls coming from source then handle it Go to output file under columns double click on the left of the output column which will open the edit column meta data window where you can sp...

what is your output(database/file)

What is the input data type/length and is the output data type (DATE) ?

I used EDIT METADATA PROPERTIES

%05d (float type) and field width =5 (float type)
column metadata properties.

Output SQL type is smallint

The input Data comes as varchar(10) - TERADATA (SOURCE) col 0000 0009508 03669 08018 08065 0003065 09620 desired output ( i used char(5)) FIXED LENGTH FILE(TARGET) 00000 09508 03669 08018 08065 03065 09620 I have tried this code if (DSLink3.col) ='0000' Then '00000' else DSLink3.col[3,7] When the jo...

are you using the derivation like this :

if IsNull(inputcol) Then setNull() else inputcolumn .?