RB function help

Yahoo Archive
1
Michael:
Looks like it works great. Thanks for your help.

-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Friday, August 25, 2000 1:27 PM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] RB function help


Try this:

IIF(WEEKDAY(TODAY()) = 1, TODAY() - 2, IIF(WEEKDAY(TODAY()) = 2, TODAY() -
3, TODAY() - 1))

-----Original Message-----
From: Urban, Kenneth [mailto:kurban@...]
Sent: Friday, August 25, 2000 1:26 PM
To: 'vantage@onelist.com'
Subject: [Vantage] RB function help


I wrote a function called 'Yesterday' that's quite simple: TODAY()
-1. I use this to print a list of yesterday's shipments. Of course, the
obvious problem for a five-day-a-week company like ours is that, when you
run it on Monday, you always return 0 records. Has someone written a
function that returns TODAY()-3 when it's Monday, TODAY()-2 on Sunday, and
TODAY()-1 every other day?

Kenneth E. Urban
Manager, Information Systems & Technology
Major Industries, Inc.
7120 Stewart Avenue
Wausau, WI 54401
(715) 842-4616 voice
kurban@...



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
2
Try this:

IIF(WEEKDAY(TODAY()) = 1, TODAY() - 2, IIF(WEEKDAY(TODAY()) = 2, TODAY() -
3, TODAY() - 1))

-----Original Message-----
From: Urban, Kenneth [mailto:kurban@...]
Sent: Friday, August 25, 2000 1:26 PM
To: 'vantage@onelist.com'
Subject: [Vantage] RB function help


I wrote a function called 'Yesterday' that's quite simple: TODAY()
-1. I use this to print a list of yesterday's shipments. Of course, the
obvious problem for a five-day-a-week company like ours is that, when you
run it on Monday, you always return 0 records. Has someone written a
function that returns TODAY()-3 when it's Monday, TODAY()-2 on Sunday, and
TODAY()-1 every other day?

Kenneth E. Urban
Manager, Information Systems & Technology
Major Industries, Inc.
7120 Stewart Avenue
Wausau, WI 54401
(715) 842-4616 voice
kurban@...