date conversion

[harikumar]

Hi ,

I have source format like 1456(2007-10-01) and in target i want to populate date as 20071001.

I have gone through the search but i didn't.

Thanks,
Harikumar

[premupdate]

Have you tried OCONV function..

[ray.wurlod]

You have to extract the date portion from the input string, perhaps using substring if the size is constant or Field() functions otherwise. Then all you need to do is to convert the hyphen characters to empty string ("") in the result.

Code: Select all

Convert("-", "", Field(Field(InLink.TheString, ")", 1, 1), "(", 2, 1))

[harikumar]

Have you tried OCONV function..

I have choosed mistakenly server edition but this prob related to parllel edition

[ray.wurlod]

My solution will work with either edition.

[BI-RMA]

Hello harikumar,

Is your input value a date-format as shown in the view-data grid of for example a DB2-stage (even though I would expect the numeric value to be 14519 then)?

If your column is in date-format you can convert it using DateToString(%date%,"%yyyy%mm%dd"). This will return the string '20071001' (not a date).