PDA

View Full Version : Date Groupings



torgerjl
11-13-2008, 02:14 PM
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.