Skip to main content
benwanless
benwanless
Contributor ⭐️⭐️⭐️⭐️
July 21, 2025
New Idea

Expand capability of the FirstDayofWeek Function

Related products:CS Rules Engine
  • July 21, 2025
  • 3 replies
  • 48 views

Hello,

I would like the ability to have the FirstDayofWeek function to consider Sunday to be the start day of the week. Right now it only is able to consider Monday as the first day of the week.

 

The workaround to solve for this is difficult to implement and maintain. I would have to split my daily time series data by snapshot Day of the week, Sundays and None Sundays.

  • For sundays, the snapshot date is the FirstDayofWeek, so no transform is needed.
  • For non-sundays, I would need to create a calculated field and use the DateDiff function with the FirstDayofWeek function and subtract one day so that instead of Monday it will return the previous day (my sunday).

Please help me solve this as I believe many businesses consider Sunday as the Start of the week.

    3 replies

    bradley
    bradley
    Expert ⭐️
    July 21, 2025

    It’s wild to have to request that the settings you use in your tenant, be applied to your tenant. 

    If you go into application settings, Fiscal years, and “Week Start Day”, that should absolutely be relevant to the FirstDayofWeek function in your tenant.

      benwanless
      benwanlessAuthor
      Contributor ⭐️⭐️⭐️⭐️
      July 22, 2025

      It’s wild to have to request that the settings you use in your tenant, be applied to your tenant. 

      If you go into application settings, Fiscal years, and “Week Start Day”, that should absolutely be relevant to the FirstDayofWeek function in your tenant.

      At first I thought this was a bug until support pointed out to me that the application settings > fiscal year has nothing to do with this Function. The related support article for Date Functions in Gainsight clearly states that it uses Monday as the start of the week.

      bradley
      bradley
      Expert ⭐️
      July 22, 2025

      It’s wild to have to request that the settings you use in your tenant, be applied to your tenant. 

      If you go into application settings, Fiscal years, and “Week Start Day”, that should absolutely be relevant to the FirstDayofWeek function in your tenant.

      At first I thought this was a bug until support pointed out to me that the application settings > fiscal year has nothing to do with this Function. The related support article for Date Functions in Gainsight clearly states that it uses Monday as the start of the week.

      Not a bug, just not good design.

      Terms & ConditionsAccessibility statement