topic Re: Subtract one workday in QlikView

Subtract one workday

Keyuser — Thu, 18 Jun 2020 11:39:44 GMT

Hy,

I’m loading a date field in my script.
Example: 01.05.2020

Now I need a second date field where I calculate following:
Date minus one workday.

Example: 29.05.2020

Thank you!

Re: Subtract one workday

tresB — Thu, 18 Jun 2020 11:49:33 GMT

I guess you meant - Example: 01.06.2020

FirstWorkDate(datefield, 1+1) as date_minus_a_workday

Re: Subtract one workday

Taoufiq_Zarra — Thu, 18 Jun 2020 11:52:26 GMT

@Keyuser

May be

=firstworkdate (Field, 3)

Re: Subtract one workday

Brett_Bleess — Wed, 08 Jul 2020 12:23:27 GMT

You have received two posts related to your use case, if either of them got you what you needed, we would greatly appreciate it if you would return to the thread and close things out by using the Accept as Solution button on the post(s) that helped you resolve things. If you did something different, you can post that in a new comment and then mark that too, and if you still have questions, please leave an update post.

Regards,
Brett