Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using LastWorkdate with negative increments

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 DateMovement (forward or backward)Date Modified
22/03/2016-1014/03/2016
23/03/2016-1015/03/2016
24/03/2016-1016/03/2016

Thanks in advance.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Problem solved. I used FirstWorkDate.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

Problem solved. I used FirstWorkDate.