BuildPro
7 months agoQrew Captain
Easy Formula Fix
Sometimes, I just can't get the hang of formulas! Please help...thank you Case( DayOfWeek([FINAL PROJECTED START DATE]), 0,"SUN", 1,"MON", 2,"TUE", 3,"WED", 4,"THU", 5,"FRI", 6,"SAT", "OPEN...
- 7 months ago
That is an unusual name for a text field type. Do you have a date field that you can use in that formula instead? But, if the contents of that field is always a properly formatted date (or blank), but just in text format, then you can try this.
Case(
DayOfWeek(ToDate([FINAL PROJECTED START DATE])),
0,"SUN",
1,"MON",
2,"TUE",
3,"WED",
4,"THU",
5,"FRI",
6,"SAT",
"OPEN")