Dear brother,
I am a hobist. I am working with VB6 and wants to report by Crystal Report9. I am using Access 2000 Data base.
I want to inter link Crystal report in VB6. I can connect and it is working with Record SelectionFurmula perfectly for Character and Number data.
But when I am using DATE Field in Recordselectionformula it is not working correctly. In data base I made DATE field Short Date.My Computer date format is also dd/mm/yyyy format .
In VB6 date query working working perfectly by format ( Examp: Format (# " & TextDate.text& "#,' mm/dd/yyyy'), bul in Crystal report9 it is not working.
Recordselectionformula can retrive dates 31/01/2006, 13/12/2006, But when Date is like 01/02/2006 or 05/06/2006 then it can't retrive any record.
Example :

Report.recordselectionformula="{TableName.DatefieldName}=#" & TextDate.Text & "#" #
If Possible help me. How can overcome it. I will be greatful to you.

Thanks