Date Format.

[Prakash Bhai]

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.

[MFGF]

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.