Using LastWorkdate with negative increments

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am trying to make Lastworkdate work with negative increments but it does not work.Does anyone had the same problem and can shed a light on this?

For example: Take a date (22/03/2016), subtract 10 day and you get 12/03/2016. After that you apply Lastworkdate function with 1 as a parameter (Lastworkdate(12/03/2016,1) and get 14/03/2016, Monday. That's ok so far.

Now take another date (23/03/2016) and do the same calculation. The result will be the same again, as above. My problem is in here:

I want user to move a selected date either to the front or behind and with that all the subsequent dates to move together.

There's an example below to illustrate better what I would like to do.

Original Date	Movement (forward or backward)	Date Modified
22/03/2016	-10	14/03/2016
23/03/2016	-10	15/03/2016
24/03/2016	-10	16/03/2016

Thanks in advance.

Re: Using LastWorkdate with negative increments

Anonymous — Tue, 22 Mar 2016 14:37:44 GMT

Problem solved. I used FirstWorkDate.

topic Using LastWorkdate with negative increments in QlikView

Using LastWorkdate with negative increments

Re: Using LastWorkdate with negative increments