Forum Discussion

Qrew Captain

2 years ago

Solved

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

Error:

MarkShnier__You
2 years 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")

4 Replies

MarkShnier__You
Qrew Legend
2 years ago
Is there any chance that your final projected start date field is actually a text field and not a date field type?
- BuildPro
  Qrew Captain
  2 years ago
  It is a formula text field. Thx
  - MarkShnier__You
    Qrew Legend
    2 years 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")
Maria
Community Manager
2 years ago
Or perhaps the field should be called [FINAL PROJECTED START WEEKDAY]