Easy Formula Fix

Question

Sometimes, I just can't get the hang of formulas! Please help...thank youCase(DayOfWeek([FINAL PROJECTED START DATE]),0,"SUN",1,"MON",2,"TUE",3,"WED",4,"THU",5,"FRI",6,"SAT","OPEN") Error:

MarkShnierYou · Accepted Answer

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")

MarkShnierYou · Answer

Is there any chance that your final projected start date field is actually a text field and not a date  field type?

Sign up

Login to the community