[CR VS2005] Crystal Syntax Date Selection.

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:

Code:

---

{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...

OK i fugired out my Error... Missing String single quotes.. 'xx/xx/xxxx'

Now a new problem.

How would i do it if i wanted to search dates using a like clause??

Code:

---

crystalsyntax = "{EQ_Equipment.equipment_warranty} = Like Date('2009')"

---

When i use the code above i recive a long error. i have tried diferent itterations DateValue, Date , Cdate. If i just use Like and no date conversion it throws an error on saying.."date, datetime..ect... Is expected here"

Any help apreciated...

Like Date() might have to be something like

year({your feild name}) = like 2009