Hi George,
>IF MyTable.DayOfWeek = DOW(DATE(), 2) THEN
> * Do your processing.
>ENDIF
Good point.
Naomi,
if you insist on the field containing the right values, simply rename the field to
nDayOfWeekMinusOne, then store 1 to 5 in it when meaning 2 to 6. and then do:
IF MyTable.nDayOfWeekMinusOne+1 = DOW(DATE()) THEN
ENDIF
Just joking ;-)
In fact the numbers 1 to 5 would better fit the optiongroup control, but you may have to change much code with the data change, either by adding one to that new day number or by comparing with DOW(Date(),2). Even setting FDOW to another value doesn't help, because for DOW() to use that setting you'd have to change the call to DOW(Date(),0), as FDOW is not automatically evaluated.
Bye, Olaf.