Beast Mode

Beast Mode

WEEKOFYEAR is not aligning to ISO-8601, is this correct?

Contributor

Hi,

I recently utilised the Week of Year function for a date column. I'm unsure if this is incrementing from 0, but the value for the 12th of Feb 2024 returns 6. I would expect it to return 7. Site faviconWeek Numbers for 2024

.

Can someone confirm if this is intended? It looks to use Sunday as the start of the week in this function.

Best,

Sam

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Answers

  • Contributor
    edited April 2024

    @Samuel.

    Have a look at using the function Week and pass into it whatever mode fits your needs.

    WEEKOFYEAR(date[,mode])

    WEEK(date[,mode])

    Both do the same thing.

    Modes are

    0: First day is Sunday, range is 0-53, first week has a Sunday in this year.

    1: First day is Monday, range is 0-53, first week has more than 3 days this year.

    2: First day is Sunday, range is 1-53, first week has a Sunday in this year.

    3: First day is Monday, range is 1-53, first week has more than 3 days this year.

    4: First day is Sunday, range is 0-53, first week has more than 3 days this year.

    5: First day is Monday, range is 0-53, first week has a Monday in this year.

    6: First day is Sunday, range is 1-53, first week has more than 3 days this year.

    7: First day is Monday, range is 1-53, first week has a Monday in this year.

    Site faviconCustomer Support Community

  • Contributor

    Hey @Jones01,

    I'm referring to the weekofyear function above. I'm fully aware of the functionality of both; I'm asking if there's a reason why the values don't align with international standards.

  • Contributor

    @Samuel. apologies I misunderstood your message.

    I've tested on my instance and I get back Week 7.

  • Contributor

    There seems to be an delta between the MagicETL calculation and the Beastmode calculation.

    MagicETL Values:

    Beastmode Values:

  • Contributor

    this probably covers why

  • Contributor

    Thanks @Jones01 - weirdly Week() in MagicETL also has the same functionality issue and returns the same value 🤦‍♂️

  • @Samuel. Do you have a default fiscal calendar set for your organization?

  • Contributor

    Hey @Garrett_Kohler, no - this setting is not seemingly enabled or used in our org.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In