type conversion
Moderators: chulett, rschirm, roy
type conversion
Hi,
I am reading from a file and writing to another file.
One of the fields need a string to date conversion I used the function
String To Date conversion in the Transformer.
When I use it it's giving out put ***** manner.
What is the reason for it?
Input data is 20061203 format output I need to get 2006-12-03.
But most of the records has 00000000 values in that field.
So I tried to give values to the null but that one also not working for
it
Is there any suggestions.
Thanks
I am reading from a file and writing to another file.
One of the fields need a string to date conversion I used the function
String To Date conversion in the Transformer.
When I use it it's giving out put ***** manner.
What is the reason for it?
Input data is 20061203 format output I need to get 2006-12-03.
But most of the records has 00000000 values in that field.
So I tried to give values to the null but that one also not working for
it
Is there any suggestions.
Thanks
Provide
Code: Select all
StringToDate(DSLink9.A,"%yyyy%mm%dd")
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
If the record has 00000000 value in that field that I am supposed to conver to date then I have given the fallwoing function.
If IsNull(DSLink9.A) Then 0 Else (StringToDate(DSLink9.A,"%yyyy%mm%dd"))
but it is giving fallowing error while compiling.
Invalid conversion requested while converting int8 to date
If IsNull(DSLink9.A) Then 0 Else (StringToDate(DSLink9.A,"%yyyy%mm%dd"))
but it is giving fallowing error while compiling.
Invalid conversion requested while converting int8 to date