Date prompt - first day, current month

[cognosun]

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

[pricter]

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

[mp.sanjeev]

Please try this

First of Month : exp                 _first_of_month ( [date] )