1

Make date_unitvalue support iso-8601 weeks

HeroBase A/S Admin

January 05, 2016 14:54

Completed

Follow

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  HeroBase A/S Admin January 05, 2016 15:04

  Here in Denmark we use iso-8601 for week numbering, which means that 2016-01-01 - 2016-01-03 is week 53 and that week 1 starts 2016-01-04. No matter what I try I can't make date_unitvalue return a value matching that numbering scheme. I had hoped that DATE_UNITVALUE( DATE( 2016.01.01, "yyyy.MM.dd"), week, Thursday) whould work, since the rule is: Week 1 is the week containing the first thursday of the year.
• 0
  
  Peter Backer January 07, 2016 22:57

  Yes please, we need this urgentie! May even be critical to decide for no/go continuing Dashboarding with KF for some of our clients who live in iso week presentations every day.
• 0
  
  Stephen Friend January 19, 2016 05:28

  Agreed with the need for this... or a work around to achieve the same thing. Any input from Kentico support?
• 0
  
  Onetomarket Admin April 06, 2016 10:15

  Yes. My client just ask why the weeks aren't syncing up correctly with their internal system CRM system.

  We also need this for a usable dashboard.

• 0
  
  Meggan King April 06, 2016 14:59

  Hi - We have released an option at the company level which should allow you to select your locale and access this option:

  https://support.klipfolio.com/hc/en-us/articles/218143727-Locale-Setting?query=locale

   

  This new feature will support iso-8601 weeks. Can you try this?

  - Meggan