Determine Day of Week (OpenInsight 32-Bit) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{tag>category:"OpenInsight 32-Bit" author:"David Nowak" author:"support@sprezzatura.com" author:"Donald Bakke" author:"dsig_at_sigafoos.org"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Determine Day of Week (OpenInsight 32-Bit) ====
=== At 29 NOV 2004 04:44:00PM David Nowak wrote: ===
 
 
<QUOTE>
Does OpenInsight 7.01 have any function whereby the day of week can be determined from the date?  For example, determine that 12/25/2004 is a Saturday.  Furthermore, what is the extent of OpenInsight's date handling capabilities outside of simply formatting the date?



Thanks in advance for any help you can provide.



David Nowak.


</QUOTE>
----

=== At 29 NOV 2004 05:16PM support@sprezzatura.com wrote:  ===

<QUOTE>Dates are stored as the number of days elapsed since Day 0 - 31st Dec 1967. Thus all date arithmetic is simply a case of manipulating the base date. Day of the week can be found by using a simple mod function



DayOfWeek=Field("Sun,Mon,Tue,Wed,Thu,Fri,Sat", ",",Mod(BaseDate, 7) + 1)



The date in 3 weeks can be determined by adding 21 to the base date, etc.



support@sprezzatura.com

The Sprezzatura Group Web Site

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 29 NOV 2004 10:30PM David Nowak wrote:  ===

<QUOTE>Thank you for the info.  But doesn't this assume that everything is based upon today's date, 3 weeks from today, for example?  What if today, I need to determine the day of week for 12/15/2004?

</QUOTE>

----

=== At 30 NOV 2004 01:19AM Donald Bakke wrote:  ===

<QUOTE>David,



The logic Sprezz gave you does not assume any given day. Thus, to use it in the example you just gave:



BaseDate=12/15/2004" ; * External format of the date

BaseDate=Iconv(BaseDate, "D4/") ; Convert to internal format

DayOfWeek=Field("Sun,Mon,Tue,Wed,Thu,Fri,Sat", ",",Mod(BaseDate, 7) + 1) ; * Return the day of the week



dbakke@srpcs.com

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]



[img]http://www.srpcs.com/srpicon1.gif[/img]

</QUOTE>

----

=== At 30 NOV 2004 02:10AM dsig_at_sigafoos.org wrote:  ===

<QUOTE>did you try the routine sprezz gave you?



dsig_at_sigafoos.org

[url=http://www.sigafoos.org/samweb]DSigs Radio Free Oregon[/url]

Phone: 971-570-2005

</QUOTE>

----

=== At 30 NOV 2004 07:47AM David Nowak wrote:  ===

<QUOTE>Thanks again to everyone.  All of this is working just fine.  I really appreciate the help.



David Nowak.

</QUOTE>


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