DSXchange

Hi I am using the function StringtoDate(Jobparameter,"%yyyy-dd-mm%")

But getting warning and no records are populating into the target.
APT_CombinedOperatorController,0: Conversion error calling conversion routine date_from_string data may have been lost
Peek_12,0: Date:**********

Could you please tell me what could be the problem
Searched in the forum but not found.


Regds

Posting a sample of your input data for this field here would help. Check if the year date and month are actually separated by "-". Also see if the date and month are always 2 characters or digits.

Maveric wrote:Posting a sample of your input data for this field here would help. Check if the year date and month are actually separated by "-". Also see if the date and month are always 2 characters or digits.

My input data is 20070101 and expected resulut is 2007-01-01


Thanks

if your string is formatet 20070101 then you need to specify that format in StringToDate(InLink.DateCol1, '%yyyy%mm%dd')

Try this. "%yyyy%dd%mm". What you are mentioning here is the format of your input. Since there is no "-" in your input data and u have specified it in the format, you were getting this warning.

Maveric wrote:Try this. "%yyyy%dd%mm". What you are mentioning here is the format of your input. Since there is no "-" in your input data and u have specified it in the format, you were getting this warning.

StringToDate(pEFFECTIVE_DATE,"%yyyy%mm%dd"%]) I am using a jobparameter PEFFECTIVE_DATE which has the string type 20070101 value now tell me what could be the derivation at the derivation column to get the output 2007-01-01

irajasekharhexa wrote:

Maveric wrote:Try this. "%yyyy%dd%mm". What you are mentioning here is the format of your input. Since there is no "-" in your input data and u have specified it in the format, you were getting this warning.

StringToDate(pEFFECTIVE_DATE,"%yyyy%mm%dd"%]) I am using a jobparameter PEFFECTIVE_DATE which has the string type 20070101 value now tell me what could be the derivation at the derivation column to get the output 2007-01-01

(pEFFECTIVE_DATE,"%yyyy%mm%dd"%) is showing invalid expression
and StringToDate(pEFFECTIVE_DATE,"%yyyy-mm-dd"%) is not giving the right output

irajasekharhexa wrote:

irajasekharhexa wrote:

Maveric wrote:Try this. "%yyyy%dd%mm". What you are mentioning here is the format of your input. Since there is no "-" in your input data and u have specified it in the format, you were getting this warning.

StringToDate(pEFFECTIVE_DATE,"%yyyy%mm%dd"%]) I am using a jobparameter PEFFECTIVE_DATE which has the string type 20070101 value now tell me what could be the derivation at the derivation column to get the output 2007-01-01

(pEFFECTIVE_DATE,"%yyyy%mm%dd"%) is showing invalid expression
and StringToDate(pEFFECTIVE_DATE,"%yyyy-mm-dd"%) is not giving the right output

Hi All

StringtoDate(pEFFECTIVE_DATE,"%yyyy%mm%dd")

This Working fine and giving correct output.

Thanks for your valuable time spent and reponse.


Regds

You will have to tell us. Is your input date format yyyyddmm or yyyymmdd?

And this is what i told you to try"%yyyy%dd%mm" And this is what you have tried ""%yyyy-mm-dd"%". Are they the same?