For point number 2: there is a function called "DayOfWeek" that you can use in the formula builder.
DayOfWeek(DateField)
this will return a number for the day of the week, and from there you can convert your number into your Day.
NumberVar DOW:= DayOfWeek(DateField);
If DOW= 1 then "Sunday" else
If DOW= 2 then "Monday" else
etc.
|