Search results for query: *

You were correct some null value in the database caused the error. I cleared out everything except for valid dates and it worked fine. Thanks for your help.

I tried what you suggested. It shows no errors when I check. When I try to run the report I get a message that says: "Bad date format string". When I click OK it highlights the cdate formula.

Is 15 the default limit? I never changed length settings. The data could be 8-10 characters. For instance 1/1/2009 or 12/12/2009.

Yes it shows Type: String, Length: 15.

The report is just a summary of what was entered for the day. It is simply counting how many entries under the specific date. The application we use writes to the database in single digits for the date. For example todays entries would say 2/26/2009.

Is there a formula that must be used? I have tried setting the date = CurrentDate but it won't pull any entries from the date. It is looking for an entry with "CurrentDate" as the date.

I have a report set up to count the number of entries from a MS SQL database based on today’s date. Currently I am changing the date (x/x/xxxx) on a daily basis via "Select Expert Record". I would like the report to run automatically with the current date without having to manually update it...