Week Number Start On Sunday as first day

Hi All

Can anyone tell me in this WEEKNUM([INSPECT TIMESTAMP])  expression week start on Sunday or Monday?

Solved Solved
0 3 121
1 ACCEPTED SOLUTION

3 REPLIES 3

WEEKNUM([INSPECT TIMESTAMP], "Sunday")

In the expression WEEKNUM([INSPECT TIMESTAMP]), the week start depends on the locale settings of the application or platform you're using. Different regions and systems may have different conventions for defining the first day of the week.

In some locales, Sunday is considered the first day of the week, while in others, it's Monday. To determine which day is considered the start of the week in your specific case, you'll need to consult the documentation or settings of the platform or application you're working with.

It's important to note that the WEEKNUM function itself doesn't dictate the week start day. Its purpose is to return the week number for a given date, based on the week start day defined by the system or locale settings.

Thanks but I dont seems to find that setting is

You're welcome

Top Labels in this Space