Passing Dates into Where Clause

[Packya]

I have a condition in Oracle SQL:

Field_name between ateParameter and ateParameter + 365

How do I do this in Crystal so that CR passes it to the SQL where clause?

 

[synapsevampire]

Use:

{Field_name} >= {?DateParameter)
and
{Field_name} <= dateadd('yyyy',1,minimum({?DateParameter)
))

in the record selection criteria.

Note that I changed the 365 to just adding a year to allow for leap years.

This will pass the SQL (using Oracle 9i native connection).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[synapsevampire]

Oooops, I had a residual MINIMUM in the previous post from my testing, use this instead:

{Field_name} >= {?DateParameter)
and
{Field_name} <= dateadd('yyyy',1,{?DateParameter)
)

in the record selection criteria.

Note that I changed the 365 to just adding a year to allow for leap years.

This will pass the SQL (using Oracle 9i native connection).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com