Re: field day of week formula

If you wanted to have a just formula numeric field to return just the numbers from 0 to 6, then you would use the formula DayOfWeek([date])

If you wanted to have a formula text field type to have the words then you would use the formula

Case(DayOfWeek([date]),

0, "0-Sunday",

1,"1-Monday",

etc

6,"6-Saturday")

So, the solution is to change your field type to be a text formula.