Re: How to 'convert' Date/Time to Date to use DayofWeek?

You need to convert the numeric output to a text value.  You would probably substitute your existing formula output for the [Date Field] as a variable in the formula below.

Case(DayOfWeek([Date Field]),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday")

------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------