Obtaining the day of the week (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 22 AUG 1998 08:02:11AM Tim Ross wrote:

AREV Specific

Can someone please tell me how to obtain the day of the week from the system date or some other source so that I can incorporate this into an AREV application. Thanks!

At 22 AUG 1998 06:50PM Victor Engel wrote:

DayOfWeek=mod(DateVar,7)

0=Sunday … 6=Saturday, thus:

"SUNMONTUEWEDTHUFRISAT" DayOfWeek*3+1,3 will give the 3 digit text for it.

At 24 AUG 1998 12:25AM Don Bakke wrote:

Tim,

Here's a nice little one liner for what you want:

Day_of_week=Field("Sunday*Monday*Tuesday*Wednesday*Thursday*Friday*Saturday", "*", Mod(Date(), 7) + 1)

Replace Date() with any variable that holds the date being used. Also, I believe credit goes to Steve Smith for the heart of this code. It's been a few years, I believe, since when I first saw it.

dbakke@srpcs.com

SRP Computer Solutions

At 25 NOV 1998 08:14PM Jim Dierking wrote:

Many Thanks! Happy Thanksgiving!

View this thread on the forum...