Re: field day of week formula

The formula for the Day of the Week is

DayOfWeek([date])

It will return a number from 0 (Sunday) to 6 (Saturday).

If you were doing a graph and wanted the day names you would need to have a formula such as

Case(DayOfWeek([date]),

0, "0-Sunday",

1,"1-Monday",

etc

6,"6-Saturday")



The reason that you might want to preface the text with numbers is to get them to sort on a graph by day of week.