I have an idea:

Make date_unitvalue support iso-8601 weeks

9 votes
Vote
Sign in
Signed in as (Sign out)
You have left! (?) (thinking…)
Actimizer Admin shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
Signed in as (Sign out)
Submitting...
  • Stephen Friend commented  ·   ·  Flag as inappropriate

    Agreed with the need for this... or a work around to achieve the same thing. Any input from Kentico support?

  • Peter Backer commented  ·   ·  Flag as inappropriate

    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.

  • Actimizer Admin commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base