Forum Discussion

KatherineOakey's avatar
KatherineOakey
Qrew Member
5 years ago

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

I have a table with records, each of which has a field containing a Date/Time, say RegisterDate. I want to be able to generate a report/chart that can sum the number of RegisterDates that are on Mo...
Formulas and functions
Laura_Thacker's avatar
Laura_Thacker
Qrew Captain
5 years ago
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
------------------------------