How to generate a date range in kdb excluding weekend days?
kdb
Solution
q)daterange where not (daterange mod 7) in 0 1
2008.06.02 2008.06.03 2008.06.04 2008.06.05 2008.06.06 2008.06.09 2008.06.10 ..
q)
Problem
This code produces a sequence of dates: ``` firstdate: 2008.06.01 lastdate: 2008.08.31 daterange: firstdate + til (lastdate - firstdate) + 1 ``` Is it possible to generate the same range excluding weekend dates (Sat/Sun)?