Day of Week Revisited
** This thread discusses the article: Day of Week Revisited **
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Day of Week Revisited
Collapse
X
-
Guest replied
-
Guest repliedDay 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:
-
Leave a comment:
-
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 repliedDay 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:
-
Day of Week Revisited
** This thread discusses the article: Day of Week Revisited **
** This thread discusses the Content article: Day of Week Revisited **
0Tags: None
Leave a comment: