How to generate a date range in kdb excluding weekend days?

Question

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)?

score 5 · Accepted Answer · answered Apr 20 '13 at 03:03

5

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)

answered Apr 20 '13 at 03:03

user1895961

I tried to add this to a q script and get an error: "date_range: arg_begin_date + til (arg_end_date - arg_begin_date) + 1". The same line typed at the q console works... – Robert Kubrick Apr 22 '13 at 16:44
Sorted out: arg_begin_date type in my script was 10h, rather than -14h as on the console. – Robert Kubrick Apr 22 '13 at 16:50

score 4 · Answer 2 · answered Apr 20 '13 at 17:44

4

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

answered Apr 20 '13 at 17:44

Sergey V

2 Answers2