Hi,
Im my database the dates are stored in an integer format for e.g. for today's date they are stored as 20070515. But the current_date is in the format 2007-05-15. If I want to put a filter to the query to return rows for today's date only then how should I go about doing it. I am using cognos 8.0.
Currently I am trying
[DateLastUpdated] = cast(current_date,integer)
but it is failing and gives error saying cannot convert date2 to integer.
Thanks a lot for your help
$wapnil
Im my database the dates are stored in an integer format for e.g. for today's date they are stored as 20070515. But the current_date is in the format 2007-05-15. If I want to put a filter to the query to return rows for today's date only then how should I go about doing it. I am using cognos 8.0.
Currently I am trying
[DateLastUpdated] = cast(current_date,integer)
but it is failing and gives error saying cannot convert date2 to integer.
Thanks a lot for your help
$wapnil