Giveing me an error when inputing date

[Czeszyn]

I have this weird problem, I have my forms set up so that I can put a date range in the boxes, a start data in one, and the end date in the other. This works great and have been using this for a couple of months now. Here is the weird part. For some reason when I wanted the date range Feb 1, 2015 to Feb 28, 2015. I get an error message. Not I can go from Jan 1, 2015 to Feb 1, 2015, or from Feb 3, 2015 to Feb 28, 2015. For some reason it does not like Feb 2, 2015 date. I am not sure what would be causing this. I hope someone has some great ideas.
Thanks in advance.
Tony :banghead:

 

[plog]

Humor me in my craziness. Now, I know this sounds ludicrous, but , and this is just a shot in the dark, stabbing at air, but, maybe, just maybe the text of that error message might hold a key which would provide some insight to the nature of that error.

Better yet, can you post your database so I can recreate it?

 

[Czeszyn]

I would send the database, but it has business personal information on. ;(

The error message reads "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too may complicated elements. Try simplifying the expression by assigning parts of the expression to variables.

Like I said it works for everything all my forms, and all other dates but not Feb 2, 2015. Must of been a bad day.

Thank you again in advance.
Tony

 

[Czeszyn]

Hey figured it out. I found that there was an empty record will no data that was holding it up. Once I took that out, it works again. Thank you for your help.

Tony