Sum works for all month ranges except august???

[wchelly]

I have a report which groups shipments by shipment type and whether it is one-way or round trip. I run the report by month so my parameter boxes query between the start date and end date of a one month period.

This works for all months except August. When I enter 8/1/2012 and 8/31/2012 I get the following error:

"This expression is typed incorrectly, or is too complex to be evalutated. For example, a numberic expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables"

When I enter 8/1/2012 and 8/30/2012 it works correctly???

I get the same error when I type in a date that does not exist...for example 2/30/2012. Except 8/31/2012 DOES exist.

It's like it doesn't know that 8/31/2012 is a real date.

 

[pbaldy]

Given what you describe, my first thought is a data problem in a record with that date. Check records with that date and see if any has anything unusual. Can't be more specific without knowing more about your data. If you can post the db here, we can check it.

 

[wchelly]

There was nothing obviously unusual but I re-entered all of the data and created a new record for that date, and it now works. Thanks!

 

[pbaldy]

Happy to help!