Novice question about date ranges

[Gonnosuke]

Hello,

I apologize in advance for asking a question that has been discussed many times (I've read the FAQ's and done keyword searches) but I've only been writing Crystal Reports for 2 days and I need some more detailed information.

Here's my situation: I'm using CR8 to retrieve information from a SQL database used by our call tracking application (Heat 6.x). I'm writing a report that will allow a user to specify the type of information they would like to query (call status, call type etc.) and also specify a date range. I've setup the parameters and experts for everything except the date range and here's my problem:

The date is stored in the DB as a string value. After reading through the help docs I thought I'd be able to do something like:

CDate(?Parameter) in (BeginDate) to (EndDate)

But it's not working. I know it's probably something really simple but I can't figure it out. I'd greatly appreciate it if someone can help me out here. Please keep in mind that I'm new so don't take anything for granted!

Thank you,
-Gonnosuke

 

[kenhamady]

What are the parameters you are using?
What data types are the parameters?
What format is the date string in the database? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)