Why doesn't DAY_OF_WEEK(TODAY()) work as a Ui-Only field?

  • 1
  • Question
  • Updated 2 years ago
  • Answered
I get a blank value in return. 

Same thing with DAY_OF_WEEK(NOW()). Can you not nest functions?

Thanks,
Seth
Photo of Seth Leonard

Seth Leonard

  • 662 Points 500 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Seth Leonard

Seth Leonard

  • 662 Points 500 badge 2x thumb
For reference, I am trying to get the date of the preceding Monday based on today's date. Getting this part to work is the first part of that.
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
Try wrapping each function in VALUE()
Photo of Seth Leonard

Seth Leonard

  • 662 Points 500 badge 2x thumb
Unfortunately, that doesn't work either.
Photo of David Giger

David Giger

  • 1,758 Points 1k badge 2x thumb
Hi Seth,

Nesting formula-functions is possible.

What is your "Formula Return Type"?
If it's anything else than "Text" or "Number" ("Percent" would also work but that won't make any sense at all in your case) it won't display anything.

The reason is, when the "Formula Return Type" is set to e.g. "Date" the formula wants to convert a number (e.g. 2) into a date, which is an invalid date and therefore returns null.
So always make sure to select an appropriate "Formula Return Type" :)

Cheers
(Edited)
Photo of Seth Leonard

Seth Leonard

  • 662 Points 500 badge 2x thumb
Ah, you're right David, thank you. I had set the field to Date, since that was my end goal. Forgot it wouldn't allow me to debug in the process.

Seth
(Edited)