Calendar week in view column

Include calendar week in a view have several advantages:

- they are selectable

- they can be compared

- a query can be created to view for which week will delivery be delayed

As an example I have created a SalesLineDeliveryView view for a sales line with 2 columns: confirmed shipping week and requested shipping week.

As columns differ only by a parameter, I have created a function that will return a week from a date:

For the first 9 weeks additional '0' will be added fir aligning.

If no datum has been entered, an empty string will be returned.

For columns I have created 2 methods

Then I have created data fields and assigned methods to them. Finally data will look like this:

You can create your own workspace and define a query to see which lines have a postponed delivery.