Hello,

I have used a report for all of 2012 and it seemed to work correctly. Now all of a sudden, it is not. The issue is my Record Selection Formula, I believe. I created two date parameters and am comparing them to a date associated with the record. When I run it for 1/1/2013 - 1/6/2013, it grabs records from 1/1/2012 - 1/6/2012 and 1/1/2013 - 1/6/2013. As I mentioned, I used it last year and it never grabbed records from 2011. Why would it do this now? log1.date is a string in the database and my parameters are dates. Please help! Here is my record selection:

{security_log1.date}   >=   CStr ({?Minimum_Date}, "MM/dd/yyyy")
and
{security_log1.date}   <=   CStr ({?Maximum_Date}, "MM/dd/yyyy")

Yes. I did that and it does return the date parameters in date format. I posted on another forum and someone gave me different code that works. It was:
Date({security_log1.date}) in [{?Minimum_Date} to {?Maximum_Date}]

I just don't see why the original code is grabbing records from the year prior and the year it is run for.

My date in the database is a string and in MM/dd/yyyy format just as my parameters in the record selection.