COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cognosun on 09 Oct 2012 12:05:26 PM

Title: Date prompt - first day, current month
Post by: cognosun on 09 Oct 2012 12:05:26 PM
Hi Gurus,

Is there any way to set 'Date prompt' to first of every current month ?

In 8.4 as you know by-default it'll choose current day of current month.

Thanks in advance.
Joys
Title: Re: Date prompt - first day, current month
Post by: pricter on 09 Oct 2012 01:46:24 PM
You can check the following link that describes the process

http://www.decisionresources.com.au/Community/Tech-Tips1/Reporting-Tech-Tips/Report-Studio--Cognos-8--Cognos-10----Setting-dynamic-defau.aspx (http://www.decisionresources.com.au/Community/Tech-Tips1/Reporting-Tech-Tips/Report-Studio--Cognos-8--Cognos-10----Setting-dynamic-defau.aspx)
Title: Re: Date prompt - first day, current month
Post by: mp.sanjeev on 10 Oct 2012 04:12:18 AM
Please try this

First of Month : exp                 _first_of_month ( [date] )