APT_CombinedOperatorController
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 82
- Joined: Fri Jun 03, 2005 5:23 am
- Location: Bangalore
- Contact:
APT_CombinedOperatorController
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
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
Rajasekhar
-
- Premium Member
- Posts: 82
- Joined: Fri Jun 03, 2005 5:23 am
- Location: Bangalore
- Contact:
-
- Premium Member
- Posts: 99
- Joined: Mon Sep 03, 2007 7:49 am
- Location: Stockholm, Sweden
if your string is formatet 20070101 then you need to specify that format in StringToDate(InLink.DateCol1, '%yyyy%mm%dd')
-------------------------------------
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
-
- Premium Member
- Posts: 82
- Joined: Fri Jun 03, 2005 5:23 am
- Location: Bangalore
- Contact:
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-01Maveric 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.
Rajasekhar
-
- Premium Member
- Posts: 82
- Joined: Fri Jun 03, 2005 5:23 am
- Location: Bangalore
- Contact:
(pEFFECTIVE_DATE,"%yyyy%mm%dd"%) is showing invalid expressionirajasekharhexa wrote: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-01Maveric 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.
and StringToDate(pEFFECTIVE_DATE,"%yyyy-mm-dd"%) is not giving the right output
Rajasekhar
-
- Premium Member
- Posts: 82
- Joined: Fri Jun 03, 2005 5:23 am
- Location: Bangalore
- Contact:
irajasekharhexa wrote:(pEFFECTIVE_DATE,"%yyyy%mm%dd"%) is showing invalid expressionirajasekharhexa wrote: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-01Maveric 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.
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
Rajasekhar