# Another Day of Week

• Question
• Updated 2 years ago
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?
• 8,940 Points

Posted 2 years ago

Mike Dwyer, Champion

• 4,736 Points
Try 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)
• 8,940 Points
In 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?

Rob Hatch, Official Rep

• 45,118 Points
Lots of questions today Bill?   I answered your question here:  https://community.skuid.com/skuid/topics/day-name-formula-in-ui-field
• 8,940 Points
That was it.  Thanks so much.