You are doing a text comparison in the SQL expression where clause, and the date format is not suitable for such an inequality.
Change the date threshold to
Let V_CYearStart=Date(YearStart(Today()), 'YYYY-MM-DD');
And the SQL where to
To_Char(LAST_UPDATE_DATE,'YYYY-MM-DD') > '$(V_CYearStart)';
Or do the date calculation using Oracle SQlL logic and compare dates with dates.
Thank you for your response. I will definitely try your solution, by the time I used another approach and it worked for me. I used this piece of code-
Try using this ‘trunc(LAST_UPDATE_DATE)<=trunc(to_date('31-DEC-2015'))' in the query in place of ‘to_char(LAST_UPDATE_DATE,'MM/DD/YYYY')<='12/31/2015’.
I tried hard coded the numbers and it worked and by the time I will make it dynamic instead of hardcoading the numbers.