topic Re: type mismatch : cannot convert from string to date in Talend Studio

type mismatch : cannot convert from string to date

Anonymous — Sat, 16 Nov 2024 12:54:10 GMT

hello,
i need to set previous day date to fetch my previous day status records so i used this code .

" TalendDate.formatDate("yyyy-MM-dd", TalendDate.addDate(TalendDate.getCurrentDate(), - 1, "dd")) "
by this code im getting previous day date but only in "string" format in stage variables but i want it in "date" format
if i changed that to "date" format it shows error like " type mismatch : cannot convert from string to date " .
how can i get the same in "date" format ? can anyone suggest me for this?

Thanks in advance
Nilesh

Re: type mismatch : cannot convert from string to date

Anonymous — Thu, 26 May 2011 09:59:34 GMT

can anyone help me for this issue asap?

Re: type mismatch : cannot convert from string to date

Anonymous — Thu, 26 May 2011 10:03:31 GMT

Hi
The method formatDate returns a String, if want a date format, use this expression:
TalendDate.addDate(TalendDate.getCurrentDate(), - 1, "dd")
Best regards
Shong

Re: type mismatch : cannot convert from string to date

Anonymous — Thu, 26 May 2011 10:31:17 GMT

for that im getting like
"Wed May 25 14:58:56 GMT+05:30 2011"
but i need a output like "2011-05-25" in date format.

Re: type mismatch : cannot convert from string to date

Anonymous — Thu, 26 May 2011 10:47:12 GMT

Hi
Change the data type of column on schema to String, then you are able to use the expression as below to formate a Date to a String.
TalendDate.formatDate("yyyy-MM-dd", TalendDate.addDate(TalendDate.getCurrentDate(), - 1, "dd"))
Best regards
Shong

Re: type mismatch : cannot convert from string to date

Anonymous — Thu, 26 May 2011 11:04:05 GMT

Ya this is what i used earlier .
now i need the same result(2011-05-18) but the datatype should be in date format because i need to merge it with my data which is in "date" datatype ..
Is "2011-05-18" format in "date" data type in talend tool....

Re: type mismatch : cannot convert from string to date

Anonymous — Thu, 26 May 2011 11:35:14 GMT

Is "2011-05-18" format in "date" data type in talend tool....

Yes, just set the date pattern as "yyyy-MM-dd", it will looks like "2011-05-18" in target.
Best regards
Shong

Re: type mismatch : cannot convert from string to date

Anonymous — Thu, 26 May 2011 12:28:13 GMT

yes i can change the format but if the data type is "date" it showing the same type mismatch error.

Re: type mismatch : cannot convert from string to date

janhess — Fri, 27 May 2011 09:26:11 GMT

TalendDate.parseDate