formula for select expert record

[locheve]

Hi,
I want to automate a sales order report i have created, based on the dispatch dates. I want it to show all orders that are overdue and due up 14 days from today.

In the select expert record option i choose the relevant date field. In the 'in the period' option there is no suitable option. so i think i need to create a formula for the date field that has no lower limit and plus 14 days (including todays date).

can anyone help?

Lorna

 

[fisheromacse]

It is Friday and this is off the top of my head without having crystal in front of me, but i think you could do something like below (substituting your date field for {table.date})

(
{table.date} in [currentdate to (currentdate+14)]
or
{table.date} < currentdate
)

 

[locheve]

thanks, will that formula include all dates that are older than todays date?

 

[lbass]

You need two dates here--one that shows the planned dispatch date and one that shows the actual. If the actual dispatch date is null until the order is filled, then try something like this:

(
isnull({table.actualdispatchdate}) or
{table.projecteddispatchdate} in currentdate to currentdate+14
)

If you can't work out the solution based on this, then please supply the fields you are working with and how you are distinguishing actual versus planned dispatch dates.

-LB

 

[locheve]

thanks this worked.