Need to extract current month,current date in relational model

[madhancognos]

Hi Gurus,
   I have only start time and end time as Time stamp in my query subjects.
   I dont have any year column,month column and date column in my query subject.
   So i derived the year,month using extract function and saved as calculated column in FM and for Date i used current_date.
   Now i am creating a chart in the R.S ,there i need some filters like current_month,Current_date,Current Year.
   Can anyone suggest how to get it in filter.
  My database is oracle
  Relational datbase
  Cognos 10.2.1 version.

Thanks in advance
K.M

[MFGF]

Hi,

So your query subject now has these derived items available?

For current year wouldn't it be [Your derived year item] = extract(year,current_date)

Similarly [Your derived month item] = extract(month,current_date)

Or am I missing something?

MF.