Crystal Report9 Date format

[siraj107]

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

[craigreilly]

Have you tried it with a time of midnight? ("2005-04-29 00:00:00")
I know many of my databases store the time in with the date field.

[siraj107]

Date can be displayed in "yyyy/mm/dd" format but I want to display in report in ""dd/mm/yyyy" . How can be done.

[shirishdawane]

Report.recordselectionformula="{TableName.DatefieldName}=#" & TextDate.Text & "#" #
Thanks

Do it in this way:

Report.recordselectionformula="{TableName.DatefieldName}=#" & Format(TextDate.Text,DD-MMM-YYYY) & "#" #

[siraj107]

Thank you for reply. I solved it in other way. But Your way is more easy and short.
Thanks