can anyone help me with this query?

[Anonymous]

after running job it gives error like unparseble date

context.Query_string="select date_key,inc_date from date_dim where inc_date >'" +TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("dd-MM-yyyy",context.Last_Loaded_Date))+"'and inc_date < now()";

[TRF]

As your date value is enclosed between '' you probably need to use a SQL conversion fonction such as to_date.
Did you try this:
context.Query_string="select date_key,inc_date from date_dim where inc_date > to_date('" +TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("dd-MM-yyyy",context.Last_Loaded_Date))+"') and inc_date < now()"

[vapukov · Accepted solution]

context.Query_string="select date_key,inc_date from date_dim where inc_date >'" +TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("dd-MM-yyyy",context.Last_Loaded_Date))+"'and inc_date < now()";

missed space

context.Query_string="select date_key,inc_date from date_dim where inc_date >'" +TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("dd-MM-yyyy",context.Last_Loaded_Date))+"'SPACE_MUST_BE_THERE and inc_date < now()";

[Anonymous]

i will try it.