Formula to extract day of the week from a date field. Does anyone know how I can define a formula that returns Monday/Tuesday/Thursday etc from a date field? The only formula I can think of requires that I define a variable ( Sunday = Day (Date expression) + 7x; where x= integer between 0 and infinity)
It needs to be UI-field. Here is a formula I found but skuid does not have “MOD”.
CASE( MOD( Date__c - DATE(1900, 1, 7), 7), 0, “Sunday”, 1, “Monday”, 2, “Tuesday”, 3,
“Wednesday”, 4, “Thursday”, 5, “Friday”, 6, “Saturday”,“Error”)
Any ideas?
Question
Another Day of Week
+14This topic has been closed for replies.
+9Try this:
DAY_NAME( {{Date__c}} )
(In your sample above, you may be missing the mustache notation on the field.)
You can get additional UI Formula references at https://docs.skuid.com/latest/en/skuid/models/ui-only-models-fields.html (Google: skuid formula)
+14In UI fields and today is Saturday
I want to return days of week in 7 separate UI_fields
DAY_NAME( TODAY() ) returns Saturday
DAY_NAME( TODAY()-1 ) returns Friday
DAY_NAME( TODAY()-2 ) returns Friday
DAY_NAME( TODAY()-3 ) returns Friday
DAY_NAME( TODAY()-4 ) returns Friday
DAY_NAME( TODAY()-5 ) returns Friday
DAY_NAME( TODAY()-6 ) returns Friday
DAY_NAME( TODAY()-7 ) returns Friday
I must have formula wrong?
+17- Nintex Employee
Lots of questions today Bill? I answered your question here: https://community.skuid.com/t/day-name-formula-in-ui-field
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.