Help Urgent

Hi K. Babu

I am using Access as back end and VB 6.0 as front end. In access I have field name reporting date and I have fixed its property as date. Which stores data as MM/DD/YYYY.

I want to fecth reports on the bases of only Months and not on exact dates.

Since, crystal report selection formula data type is string, and my access datatype for the field is date, my problem is when I write my code only on months, the crystal report gives me message "Error in formula".

How should I write my code so that selection formula searches only months instead of comparing entire date field in the database and give me reports?

I will appreciate, if you could guide me ASAP.

RakeshI haven't used the SelectionFormula very much, but here's my thoughts...

If you want all the records for the month of April (for example), can't you just search for the records that are between 04/01/2004 and 04/30/2004? That way you still get the data you want and you're giving the query what it wants (a full date instead of just a month).