3 Replies Latest reply on Jul 15, 2016 4:31 PM by Shinichiro Murakami

    Defining start of week through datepart function not working?

    Maximus Decimus Meridius

      I need to set Monday as start of the week (which I have done in the datasource date properties) but am having no luck with my week functions.

       

      datepart('weekday',#2016-07-15#, 'Monday') returns 6 - meaning it's basing it off a Sunday week start. It doesn't matter what I pass as the third argument

       

      datepart('weekday',#2016-07-15#, 'Wednesday') still returns 6.

       

      In a fair and just world datepart('weekday',#2016-07-15#, 'Monday') would return a 5 - what am I missing?