query between two dates

[qwertnard]

Hello, I am trying to query data from a business objects universe. This report is being run on a monthly basis. I need to query from the first of the month three years ago to the last day of the previous month for the current year. The below is the code I tried to create. It did not work and for those of you observant enough. The Calendar year object and Calendar Month number are in a numeric format. I do have access to some date formatted objects.

=(Incident Count) Where ((([Calendar Year Number (yyyy)]*100)+[Calendar Month Number]) <=Max((([Calendar Year Number (yyyy)]*100))+[Calendar Month Number]))and ((([Calendar Year Number (yyyy)]*100)+[Calendar Month Number]) >=Max((([Calendar Year Number (yyyy)]*100))+[Calendar Month Number]))-300

Any Help would be appreciated thanks

-Qwertnard

 

[SkipVought]

Hi,

This is a Microsoft Access forum, not Business Objects.

The BO report filter syntax I've used don't look like what you posted the a WHERE in the filter???