return day of week

  • 1
  • Question
  • Updated 8 months ago
  • Answered
If today is friday and I am using UI-fields, why does the following not return "Friday"?

IF(  DAY_OF_WEEK(  TODAY()    ) ==   "6"
,
"Friday"
,
""
)
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb

Posted 8 months ago

  • 1
Photo of Mike Dwyer

Mike Dwyer

  • 3,390 Points 3k badge 2x thumb
Day_of_Week() returns a number. Compare to 6, not the character "6".

IF ( DAY_OF_WEEK( TODAY() ) == 6, "Friday", "")
(Edited)
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb
da!  Thanks Mike.
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb