[[https://www.revelation.com/|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]]


==== Function to return day of week? (AREV Specific) ====
=== At 25 NOV 1998 02:06:34PM Jim Dierking wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
I would like to creat a symbolic field that shows the day of the

week for a given date in another field.  I didn't see any dictionary

formats that allow this.  Any suggestions would be appreciated.

TIA, Jim Dierking
</QUOTE>
----

=== At 25 NOV 1998 02:26PM Victor Engel wrote:  ===

<QUOTE>There are [url=http://www.revelation.com/WEBSITE/DISCUSS.NSF/f12696d31000b22a8525652b00831bb2/2A3B7F3C765E83058525666800421E86?OpenDocument]two ways[/url] to do this on another thread. Both are based on the fact that mod(date,7) has a 1 to 1 correspondence with the day of the week.

</QUOTE>

----

=== At 25 NOV 1998 07:55PM Jay Fox wrote:  ===

<QUOTE>FUNCTION GET.DAY.OF.WEEK(DATE)

*DATE IS ANY DATE IN INTERNAL REV FORMAT



DAY=MODE(DATE,7)+1

BEGIN CASE

 CASE DAY=1;DAY=SUNDAY"

 CASE DAY=2;DAY=MONDAY"



 ETC, ETC, ETC



 CASE DAY=7;DAY=SATURDAY"

END CASE

RETURN DAY

 

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=502E2C26705CEE33852566C70068F8FA|View this thread on the  forum...]]