Date Groupings
A report we are using groups projects by month; the boss went and closed a bunch of Sept. projects late, so now they all show Oct. Now we are having to modify to code to break them out; I can not get the following formula to work:
not ({CLOSED_PROJECTS.REQUEST_ID} in [37727.00, 37494.00...]) and
if {CLOSED_PROJECTS.REQUEST_ID} IN [33963.00,34067.00...]
then IsDate (09/2008) else
{CLOSED_PROJECTS.COMPLETION_DATE} <= Maximum(lastfullmonth)
Maybe a date part in a formula where the last line is since I am using that as my selection.
Reply With Quote