Month-To-Date in Reportnet

[steffs]

How do you report on data at the Month to Date, Week to Date and Year to date intervals. Are there any functions in Reportnet specific for this kind of reporting?

 

[cutiger93]

This may help or start you in the right direction if you are using SQL Server

convert(varchar(10),[Model].[ImageSentLogTbl].[sentdate],101)

Also look at the Functions in the Cognos and read the help on them. This will begin giving you what you want.

 

[DataVixen]

For Month to Date:

[Order date] between _first_of_month(current_date) and _last_of_month(current_date)

Year to Date: (Sql Server Function)

year([Order date]) = year(current_date)

Not completely certain about Week to Date, but this will give you the last 7 days prior to the current date (report run date):

[Order date] between _add_days(current_date,-1) and _add_days(current_date,-8)