how is it possible that the combination of calendar week and year is sorted correctly on my timeline? Starting with 1-2019, 2-2019, 3-201944-2019, 45-2019
image1338212 24.1 KB
Many thanks!
Best regards,
Jonas
Hello all,
how is it possible that the combination of calendar week and year is sorted correctly on my timeline? Starting with 1-2019, 2-2019, 3-201944-2019, 45-2019
image1338212 24.1 KB
Many thanks!
Best regards,
Jonas
how is it possible that the combination of calendar week and year is sorted correctly on my timeline? Starting with 1-2019, 2-2019, 3-201944-2019, 45-2019
image1338212 24.1 KB
Many thanks!
Best regards,
Jonas
Page 1 / 1
Hi Jonas,
there are two options:
Best
David
there are two options:
You can prepend a 0 if the week is smaller than 10:
CASE WHEN CALENDAR_WEEK(VBAP.ERDAT)<10 THEN 0 ELSE END ||
CALENDAR_WEEK(VBAP.ERDAT) || - || YEAR(VBAP.ERDAT)
The other option would be to use this formula:ROUND_WEEK("VBAP"."ERDAT"), and then specify this format pattern:%U-%Y, which formats the date returned by ROUND_WEEK as [Week]-[Year]. With this solution however, your numbers will change a bit, because both solutions differ in how the week of the years is determined (In CALENDAR_WEEK; the first week of the year is the week with January 4th, you dont have this behavior in option 2. So the first week and then also all subsequent weeks might be shifted.)
Best
David
Hi David,
many thanks for your reply. I adjusted the first option a bit and now get the right result.
image101446 3.84 KB
Thanks for your help.
Best regards,
Jonas
many thanks for your reply. I adjusted the first option a bit and now get the right result.
image101446 3.84 KB
Thanks for your help.
Best regards,
Jonas
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.