Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
28 days ago

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:  

 

formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    28 days 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")

     

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    28 days ago

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

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        28 days 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")

         

  • MariaPeralta's avatar
    MariaPeralta
    Community Manager
    28 days ago

    Or perhaps the field should be called [FINAL PROJECTED START WEEKDAY]