current date + 1(cannot retrieve data from tomorrows date)

[katcol]

i am using a database, currently looking at {deliverydate} through which i display tomorrows despatch totals by supplier. the problem is i have to update the delivery date range before running, but would like to run the report automatically using easyview. can someone suggest how i would write the formula remove the need to manually alter...

thanks Colin

 

[lbass]

It is unclear what the problem is. Please try again.

-LB

 

[katcol]

lbass
the report looks at orders and delivery dates. i can range the "deliverydate" from 2009-02-27 to 2009-02-27 and results are a list of suppliers showing counts of orders quantities. i currently use "easyview" to run sheduled reports but cannot figure out to do so when the deliverydate range required is for tomorrow's date(or two days ahead etc)..

thanks Colin

 

[Lochbel]

try
{deliverydate}=Currentdate+1

This is the simple version.
You would need more code to take non business days into account (e.g. Monday deliveries, if running on a Saturday).


Lochbel
Australia

 

[AndersonCJA]

Could you use the sql expression field to select the minimum delivery date where the delivery date is greater than the currentdate?

 

[CR85user]

What selection criteria are you using currently?

If you wish for the end user to amend the date range applicable then simply point the date field to be within the parameter range:

{table.date} in {?daterange}

If you are instead compiling scheduled reports to automatically be preset to certain ranges then just use the currentdate special field as instructed.

The more info you can give the better we will be able to assist.

'J

CR8.5 / CRXI - Discovering the impossible

 

[lbass]

Colin,

I'm wondering whether this is a viewer issue instead of a CR issue. In CR you can obviously use currentdate + 1 for tomorrow's date, and you clearly realize that, so why can't you use that?

-LB