Hi All,
I have a column called Dis-Date in my DB which is in the format (dd-mm-yyyy). I have a requirement where Dis-Date has to be greater than the current date. But when I pull Current_Date from Available functions in cognos, It is displaying (Dec 2,2010). I tried to use char(current_date). But the values are displayed in (yyyy-mm-dd). I want in the format (dd-mm-yyyy). Even I tried using (char(current_date),'dd-mm-yyyy')). But the report gets validated,but at the execution time it throws SQL bulk function error -9.
How to convert that in to specified string in RS 8.4.1. Both the formats have to be in dd-mm-yyyy format.
Regards
Abhi.
Hi,
Is the Dis-Date column stored in the database as a Date data type, or as a Char data type?
Assuming it is the former, you can simply add a detail filter with the syntax
[Dis-Date] > Current_date
Regards,
MF.