Add ISO Week Numbers to Date Picker

1

Hi Arno,

while waiting on an integration, maybe this could be a work-around for displaying the ISO week after picking a date
OR the base for picking an ISO week and than displaying a choice field with the seven possible days:

See the attached picture (we use it as global business rule as part of our library):

Business Rule with SQL: select datepart(iso_week, '{BRP:365}') with {BRP:365} = Parameter in date format

In our case, we use TEXT as return value (we use it as info column in reports), in some other cases this could be a problem with sorting (1,11,12,..,2,20,..), but
changing the return value type should not be the problem ;-).

Hope this helps for now,
Bjoern

Thanks for your reply Bjoern.

I have created something of a workaround for it. See screenshot.
Year is selected automatically, but could also be changed to next year.
Week number can be typed and when pressing enter the range is displayed and the start date on Monday is filled.

Best regards,

Arno

Hi Arno, we'll analyze your suggestion and decide what to do about it against other priorities in the backlog. In the meantime, let's see if there's more people needing this.