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?