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?
You have Excel on the brain Bill. In Excel days are numbers and you can do this sort of math. Skuid uses more standard date fields and you can’t just do “Today() - 1” and expect to get a valid date for yesterday…
You can get what you are after with a combination of date formatting formulas and pre-populated date fields. Unfortunately its not super clean. For every day name you want to return you need two fields. One is a UI Only Date field that is prepopulated with a default value like “N_DAYS_AGO:1” . This returns the date field you need. The second field merely reformats that date using the DAY_NAME function.
(This begs a question - why do you need this list? There have to be better ways to get this done…)
Posted below are is some XML of an exploration page I created… It may be helpful.
TODAY() FORMAT_DATE(“DD”,TODAY()) DAY_NAME(TODAY()) VALUE(TODAY())-1 DAY_NAME({{Yesterday}}) DAY_NAME({{Day2}})
