Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Day of Week Revisited

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

  • Guest's Avatar
    Guest replied
    Day of Week Revisited

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

    Leave a comment:


  • Guest's Avatar
    Guest replied
    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

    Leave a comment:


  • Guest.Visitor
    replied
    Day of Week Revisited

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

    Code

    Leave a comment:


  • cramer@multi-support.dk
    replied
    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.

    Leave a comment:


  • Guest's Avatar
    Guest replied
    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

    Leave a comment:


  • MCWebsite.Staff
    started a topic Day of Week Revisited

    Day of Week Revisited

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