[CR VS2005] Crystal Syntax Date Selection.

[smilbuta]

Hello,

Im trying to generate a Crystal Syntax Query to pass to a Crystal Report.

The value is a Date feild in a Sql Database stored in shortDate format [ 5/26/2009 12:00:00 AM ]

Here is the syntax:

{EQ_Equipment.equipment_warranty} = DateValue(05/26/2007)

This returns no values. yet that is an exact date in the system.

What is the correct way to build the date syntax correctly to read the Date feild above???

Thanx...