Warning: Undefined array key 125517 in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3534

Warning: Trying to access array offset on value of type null in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3536

Warning: Trying to access array offset on value of type null in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/user.php on line 704

Warning: Undefined array key "online" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/content.php on line 3548

Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635

Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635

Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635

Warning: Trying to access array offset on value of type bool in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 635

Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72

Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72

Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77

Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77

Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72

Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72

Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77

Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77

Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72

Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72

Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77

Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77

Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72

Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72

Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77

Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77

Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72

Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 72

Warning: Undefined array key "reputationimg" in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77

Warning: Trying to access array offset on value of type null in /home/duptmor/public_html/prod.mcpressonline.com/forum/includes/vb5/template.php(404) : eval()'d code on line 77

Warning: Undefined array key "birthday_search" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 173

Warning: Undefined array key "joindate" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 190

Warning: Undefined array key "posts" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 191

Warning: Undefined array key "posts" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 197

Warning: Undefined array key "userid" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 6509

Warning: Undefined array key "userid" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 212

Warning: Undefined array key "privacy_options" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/api/user.php on line 251

Warning: Undefined array key "userid" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 4998

Warning: Undefined array key "userid" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 1585

Warning: Undefined array key "lastactivity" in phar:///home/duptmor/public_html/prod.mcpressonline.com/forum/core/vb/vb.phar/library/user.php on line 1601
Day of Week Revisited - MC Press Online Forums

Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Day of Week Revisited

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Day of Week Revisited

    ** This thread discusses the article: Day of Week Revisited **
    ** This thread discusses the Content article: Day of Week Revisited **
    0

  • #2
    Day of Week Revisited

    ** This thread discusses the article: Day of Week Revisited **
    Use the DAYOFWEEK scalar function when the week should begin on Sunday as day 1 (thru Saturday as day 7). c/EXEC SQL Set Option DatFmt = *ISO c/END-EXEC c/EXEC SQL Set :MyDayNumber = DAYOFWEEK( ateISO ) c/END-EXEC Use DAYOFWEEK_ISO scalar function when the week should begin on Monday as day 1 (thru Sunday as day 7). c/EXEC SQL Set Option DatFmt = *ISO c/END-EXEC c/EXEC SQL Set :MyDayNumber = DAYOFWEEK_ISO( ateISO ) c/END-EXEC

    Comment


    • #3
      Day of Week Revisited

      ** This thread discusses the article: Day of Week Revisited **
      There is a typing error in the procedure implementation of getDayOfWeek. It says DayOfWeek in the B and PI line, it should be getDayOfWeek.

      Comment


      • #4
        Day of Week Revisited

        ** This thread discusses the article: Day of Week Revisited **

        Code

        Comment


        • #5
          Day of Week Revisited

          ** This thread discusses the article: Day of Week Revisited **
          Hi Bob, The date format Lilian is a count of the number of days since the Gregorian calendar was introduced which is why the start date is 14th October 1532. You can use the CEEDAYS api to convert your date into Lillian and then use getdayofweek, or any other kind of mathematics for that matter. Matt

          Comment


          • #6
            Day of Week Revisited

            ** This thread discusses the article: Day of Week Revisited **

            Comment

            Working...
            X