I created a report with date range prompts. I ran this report and gave date range values, but, it gave me the following error. “The string representation of a datetime value is out of range” Then I removed the date range prompts ,it worked fine. I used ‘Greater than or equalto’ and ‘Less than or equalto’ operators for the date range. It didn’t work out. Then I created a condition like ‘Date Equalto date1’, but I got the same error. Please folks help me out by giving the best solution. I will appreciate it.
Thanks
Ravi.
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
Sounds like your are trying to enter in the format opposite of what your database is expecting. If you enter in 1/31/2000 and you database is expecting dd/mm/yyyy then you will get that “type” of exception. Experiment with your formats and look for a file called .sbo in the Data Access <your database> folder. Within that file it will depict what format it is passing to your database.
Ian Humphries
Decision Support Specialist
PowerQuest Corp.
Phone : (801) 705-8527
Fax : (801) 705-4527
Email : ian.humphries@powerquest.com
I created a report with date range prompts. I ran this report and gave date range values, but, it gave me the following error. “The string representation of a datetime value is out of range”