How to create a date range in kdb excluding weekends?

Question

This code creates a sequence of dates:

firstdate: 2008.06.01
lastdate: 2008.08.31
daterange: firstdate + til (lastdate - firstdate) + 1

Is it possible to create the same range excluding weekend dates (Sat / Sun)?

+5

Robert Kubrick Apr 20 '13 at 1:41

2 answers

it would be easier to do daterange where 1<daterange mod 7

+3

Sergey V Apr 20 '13 at 17:44

user1895961 · Accepted Answer · 2013-04-20T03:03:31+0000

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)