Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
bullish35
Creator II
Creator II
‎2012-11-29 02:38 AM

Derive StartDate by subtracting number of week days from FinishDate

Hello Community!

I am working with a 'EndDate' value and have to calculate the 'StartDate' value based on a duration of 17. The easy answer is . . .

     AddDays(EndDate, -10) as StartDate

However, when calculating the StartDate, I need to subtract 17 work days and exclude weekends from my calculation.

     In simple mathematical terms, I want to solve for EndDate - 17 working days = StartDate

Without both a start and finish date, I can not use the NetworkDays function. (I've reviewed this post: Excluding weekends from one date minus another..; different issue.)

Any suggestions or examples? Either would be greatly appreciated.

Regards,

Ellen

490 Views
0 Likes
0 Replies