Specific Date Error

[joseph1111]

Whenever I try to select records by a specific date I get no data returned. If I use the between date function everything is fine. If I use after but before, I get data returned. It's only when I pull from the date specifically. This just started happened. I tried reloading Crystal but it didn't help. I'm using V8.0. Any insight would be greatly appreciated.

 

[herrld]

I would check out your file options. On the Reporting tab, under 'When Reading Data' you may need to select the Convert to Date option for the Date-Time field.

 

[joseph1111]

I've done that and everything is as it should be there. The odd thing is if I search for a date, for example:after 5/28/01 and before 5/30/01 it will return the 29th's data but if I search for 5/29/01 I get blanks.

 

[Guest_imported]

What is the database? Sounds like a corrupt index to me.

 

[MalcolmW]

This problem usually happens because there is a time value associated with the date. Try creating a couple of formulas, one that gets the date only, and one that gets the time only, just to see what is happening.
DateValue({YourField}) //Date formula
TimeValue({YourField}) //Time formula
Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[joseph1111]

It's a SQL 7.0 database and I have re-indexed. I tryed doing a time value only and it worked. Any ideal on the fix to get it to accept dates as well? Thanks.

 

[MalcolmW]

I suspect that when you ask for 5/28/01 to 5/29/01, you want 5/28/01 00:00:00 to 5/29/01 23:59:59,
not 5/28/01 00:00:00 to 5/29/01 00:00:00.
Is that the problem? Malcolm Wynden
Authorized Crystal Engineer

http://www.wynden.net

malcolm@wynden.net