comparing dates with different data types

[cancer2006]

I am using CRW 8.5 and ACCESS97
I have to select data based on the following condition.
Get all the records where date field is null or date >= 01/01/2007

I am coding as follows

If is null ({table.datefiel}) OR {table.dateield} >= "01/01/207"

Is it possible to do something like this?

 

[synapsevampire]

Use Report->Recordslection->Formula and try:

(
isnull({table.datefiel})
or
{table.dateield} >= cdate(2007,1,1)
)

Consider creating a parameter instead of hard coding the date,and reference the parameter:

(
isnull({table.datefiel})
or
{table.dateield} >= {?MyParameter}
)

Why did you mention different data types in the heading and nothing in the post???

If your date info is stored in a non date type, convert it to a date and do the compare.

-k

 

[cancer2006]

Thanks for your help.