I think you might save yourself a lot of grief by adding a formula field to your object:

Day_Before__c as “Week_End__C - 1”

Hi Joe, was Mike’s tip helpful for you?

It was actually. I just tried it and this way is a lot simpler, thanks.

One of the things I tried in that formula was replacing those YEAR(), MONTH(), and DAY() functions with the YEAR_UTC() functions. But I didn’t see one available for DAY(). There is a UTC version for all of the other date functions like that, which I think would bypass the timezone issue I was having. Is there a reason the DAY_UTC() function is missing?

Mike, thank you for sharing your knowledge!
Happy to hear that it was helpful.

Joe, do you know the list of functions in our documentation?
https://docs.skuid.com/latest/en/skuid/models/ui-only-models-fields.html

You will find a function called “DAY_OF_WEEK_UTC”, is that what you are looking for?

One more general question, did you double check the selected timezone in the user settings?

That was the document I was working off of. DAY_UTC isn’t there. DAY_OF_WEEK is a different function than DAY, so that won’t work either.

There is YEAR_UTC, MONTH_UTC, HOUR_UTC, MINUTE_UTC, and SECOND_UTC. It’s weird that DAY_UTC is missing.

And I could just set my timezone to EST. But If I am physically in MST I don’t want to have to change my timezone just so my skuid pages will work.