Last7Days, what about 10 days or 15 1

[cjbrown815]

Hi,
CRXIr2, SQL 2000, XP Pro

There is a predefined function for Last7Days, can I change that to 10 days or 15?

Thanks

-CJ

 

[synapsevampire]

No, but the following works fine:

(
{table.date} >= currentdate-9
and
{table.date} <= currentdate
)

Adjust the -9 accordingly.

-k

 

[cjbrown815]

It says my formula result must be a string. To my knowledge thats a date field

-CJ

 

[cjbrown815]

It says data type is datetime in enterprise manager.

-CJ

 

[synapsevampire]

Where are you placing the formula?

It should be in Report->Selection formula->Record

-k

 

[cjbrown815]

thanks a bunch Syn, your one of the best

-CJ