Suche
  • androsjuk

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.

0 Ansichten

Ruslan Androsjuk

Technical Solution Architect

+49 178 554 05 12

+49 521 963 06 366

Bielefeld, Deutschalnd

©2019 architect-dynamics.de.
Erstellt mit Wix.com