Talend community forum / type mismatch : cannot convert from string to date

nilesh · 2011-05-26 10:54:14

Tags: [bug, context, database, date, delimited file, error, error management]

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

nilesh · 2011-05-26 10:59:34

can anyone help me for this issue asap?

shong · 2011-05-26 11:03:31

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

Best regards
Shong

nilesh · 2011-05-26 11:31:17

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.

shong · 2011-05-26 11:47:12

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

nilesh · 2011-05-26 12:04:05

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....

shong · 2011-05-26 12:35:14

Hi

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

nilesh · 2011-05-26 13:28:13

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

janhess · 2011-05-27 10:26:11

TalendDate.parseDate

Announcement

Unanswered posts

#1 2011-05-26 10:54:14

type mismatch : cannot convert from string to date

#2 2011-05-26 10:59:34

Re: type mismatch : cannot convert from string to date

#3 2011-05-26 11:03:31

Re: type mismatch : cannot convert from string to date

#4 2011-05-26 11:31:17

Re: type mismatch : cannot convert from string to date

#5 2011-05-26 11:47:12

Re: type mismatch : cannot convert from string to date

#6 2011-05-26 12:04:05

Re: type mismatch : cannot convert from string to date

#7 2011-05-26 12:35:14

Re: type mismatch : cannot convert from string to date

#8 2011-05-26 13:28:13

Re: type mismatch : cannot convert from string to date

#9 2011-05-27 10:26:11

Re: type mismatch : cannot convert from string to date

Board footer