RB Date Calculation

Thanks, that's a much simpler formula. Where were you this morning when I
was entering Patrick's GIANT if statement formula that Todd sent? Either
way, my users are thrilled not to have to change date filters ever again on
this report! Thanks.

> -----Original Message-----
> From: Steve Sanders [mailto:ssanders@...]
> Sent: Wednesday, September 18, 2002 3:18 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] RB Date Calculation
>
>
> Nora,
> Here are the formulas that I use for the same situation:
>
> START_DATE:
> TODAY() - (WEEKDAY(TODAY()) + 6)
>
> END_DATE:
> TODAY() - WEEKDAY(TODAY())
>
> Works like a champ.
> \Steve
>
>
Our weekly labor periods run from Sunday thru Saturday. If I want to run a
report builder report for that period on any day during the following week,
is there a way to design calculated date filters so that we don't have to
enter dates every time we run the report, no matter what day of the
following week you run it?
Thanks,
====================================================================== Nora
Story
Spectra Technologies

Project Administrator
1505 Royal Parkway

Phone: 817-540-4475 ext.105
Euless, Texas 76040

Fax: 817-540-4439
Nora_Story@...

======================================================================



[Non-text portions of this message have been removed]
Nora - this was posted originally by Pat Winter ... It should point you in
the right direction ...

----------------------

Create a variable Start_Date using the WEEKDAY command which will give you a
number 1=Sunday thru 7=Saturday.

Start_Date = IIF(WEEKDAY(TODAY()) = 1,TODAY() - 6,
IIF(WEEKDAY(TODAY()) = 2,TODAY(),
IIF(WEEKDAY(TODAY()) = 3,TODAY() - 1,
IIF(WEEKDAY(TODAY()) = 4,TODAY() - 2,
IIF(WEEKDAY(TODAY()) = 5,TODAY() - 3,
IIF(WEEKDAY(TODAY()) = 6,TODAY() - 4,
IIF(WEEKDAY(TODAY()) = 7,TODAY() - 5,TODAY())))))))

The number of days to subtract depends if you want to use a = or >= in your
filter.

In my example you would need >= in the filter.

Whatever day of the week your report is run on you will get the sales for
Monday to Date.

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.00.317, Progress 9.1a

------------------------

-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Wednesday, September 18, 2002 9:13 AM
To: vantage@yahoogroups. Com
Subject: [Vantage] RB Date Calculation


Our weekly labor periods run from Sunday thru Saturday. If I want to run a
report builder report for that period on any day during the following week,
is there a way to design calculated date filters so that we don't have to
enter dates every time we run the report, no matter what day of the
following week you run it?
Thanks,
====================================================================== Nora
Story
Spectra Technologies

Project Administrator
1505 Royal Parkway

Phone: 817-540-4475 ext.105
Euless, Texas 76040

Fax: 817-540-4439
Nora_Story@...

======================================================================



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=234081.2377872.3808768.2225242/D=egroupweb/S=17050071
83:HM/A=1225247/R=0/*http://ad.doubleclick.net/clk;4547223;7007303;y?http://
www.ameriquestmortgage.com/welcome.html?ad=Yahoo01>

<http://us.adserver.yahoo.com/l?M=234081.2377872.3808768.2225242/D=egroupmai
l/S=:HM/A=1225247/rand=470173059>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
Nora,
Here are the formulas that I use for the same situation:

START_DATE:
TODAY() - (WEEKDAY(TODAY()) + 6)

END_DATE:
TODAY() - WEEKDAY(TODAY())

Works like a champ.
\Steve

-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Wednesday, September 18, 2002 9:13 AM
To: vantage@yahoogroups. Com
Subject: [Vantage] RB Date Calculation


Our weekly labor periods run from Sunday thru Saturday. If I want to run
a
report builder report for that period on any day during the following
week,
is there a way to design calculated date filters so that we don't have to
enter dates every time we run the report, no matter what day of the
following week you run it?
Thanks,
======================================================================
Nora
Story
Spectra Technologies

Project Administrator
1505 Royal Parkway

Phone: 817-540-4475 ext.105
Euless, Texas 76040

Fax: 817-540-4439
Nora_Story@...

======================================================================



[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]