DAYOFWEEK function

Posted by Yves Ste-Marie on July 02, 2014 at 10:56:27:

Anyone knows how to use this function ?

DayOfWeek
From CometWiki
Jump to: navigation, search
DayOfWeek Function -- Part of the CometDate series of functions.

Syntax: DayOfWeek(CometDate)

Discussion: The CometDate DayOfWeek function extracts the Day of the week from a CometDate Date Serial Number. CometDates are based on a date of January 1, 1800. CometDates before that date are negative and after are positive.

CometDate Weeks begin on Sunday ... The DayOfWeek function for any Monday will yield 2.

The CometDate functions respect the rules for leap years (i.e., the years 1800 and 1900 were not leap years, but the year 2000 is a leap year).

The practical range of CometDates is -657071 (01/01/01) to 2994623 (12/31/9999) but dates outside of that range may be usable in some contexts. There is no year 0 AD, The date goes from 1BC to 1AD.

Follow Ups:

• Re: DAYOFWEEK function Yves Ste-Marie 11:27:53 07/02/14 (3)
  • Re: DAYOFWEEK function Grant Foraker 13:44:30 07/02/14 (2)
    • Re: DAYOFWEEK function Bob A 05:40:54 07/03/14 (1)
      • Re: DAYOFWEEK function Grant Foraker 10:42:28 07/03/14 (0)

Post a Followup

Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.