Alex,
Create a calculated field callled "EndDate" using this formula:
iif(WEEKDAY(TODAY()) = 2, TODAY() + 4, TODAY() + 6)
WEEKDAY(date) returns the day of the week with Sun=1, Mon=2,.. Sat=7.
Since you want today plus the next four weekdays; I presume you don't ship
on weekends; if today is Monday then the next 4 days works. However, any
other weekday, add 6 so that you include 2 weekend days.
You cannot use calculated fields in an "IN-RANGE" expression in the filter,
you will need two lines in the filter similar to this:
Invhead.InvoiceDate >= Date_rb ( this is a built-in calculated
field that = Today() )
and InvHead.InvoiceDate <= EndDate.
Regards
Jim Stetter
-----Original Message-----
From: Alex Neutgens [mailto:alex.neutgens@...]
Sent: Friday, January 26, 2001 3:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage]
Does anyone know how to put a filter on a report builder report to just
print order releases (or anything else) shipping today and the next four
days (preferably only weekdays) only. Thanks for the help.
Alex Neutgens
Controller
Circuit Check, Inc.
763-694-4110
eGroups Sponsor
To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com
[Non-text portions of this message have been removed]
Create a calculated field callled "EndDate" using this formula:
iif(WEEKDAY(TODAY()) = 2, TODAY() + 4, TODAY() + 6)
WEEKDAY(date) returns the day of the week with Sun=1, Mon=2,.. Sat=7.
Since you want today plus the next four weekdays; I presume you don't ship
on weekends; if today is Monday then the next 4 days works. However, any
other weekday, add 6 so that you include 2 weekend days.
You cannot use calculated fields in an "IN-RANGE" expression in the filter,
you will need two lines in the filter similar to this:
Invhead.InvoiceDate >= Date_rb ( this is a built-in calculated
field that = Today() )
and InvHead.InvoiceDate <= EndDate.
Regards
Jim Stetter
-----Original Message-----
From: Alex Neutgens [mailto:alex.neutgens@...]
Sent: Friday, January 26, 2001 3:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage]
Does anyone know how to put a filter on a report builder report to just
print order releases (or anything else) shipping today and the next four
days (preferably only weekdays) only. Thanks for the help.
Alex Neutgens
Controller
Circuit Check, Inc.
763-694-4110
eGroups Sponsor
To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com
[Non-text portions of this message have been removed]