Business calendar not formatting correctly

[Andrew Castro]

I have a business calendar:

* Business calendar "market" created by -bcal create-
* Created/replaced on  3 Dec 2016

version 14
dateformat mdy

range jan012003 dec022016
centerdate jan012003

omit dayofweek (Sa Su)

I'm trying to apply to this dataset:

* Example generated by -dataex-. To install: ssc install dataex
clear
input float date
15706
15707
15708
15711
15712
15713
15714
15715
15718
15719
end
format %td date

I try running

format date %tbmarket

, but it does not seem to work. For example, January 10, 2003 and January 13, 2003 still have a difference of 3 units (3 days), but since the days inbetween are weekends, there should be a difference of 1 unit (1 day). Am I misunderstanding something?

[Anders Alexandersson]

Thank you for creating a simple data example using dataex. Use the function bofd() to create the business date variable.

generate bdate = bofd("market", date)
gen tomorrow = bdate + 1
gen yesterday = bdate - 1
format bdate tomorrow yesterday %tbmarket
list

This is the output.

     +-----------------------------------------------+
     |      date       bdate    tomorrow   yesterday |
     |-----------------------------------------------|
  1. | 01jan2003   01jan2003   02jan2003          -1 |
  2. | 02jan2003   02jan2003   03jan2003   01jan2003 |
  3. | 03jan2003   03jan2003   06jan2003   02jan2003 |
  4. | 06jan2003   06jan2003   07jan2003   03jan2003 |
  5. | 07jan2003   07jan2003   08jan2003   06jan2003 |
     |-----------------------------------------------|
  6. | 08jan2003   08jan2003   09jan2003   07jan2003 |
  7. | 09jan2003   09jan2003   10jan2003   08jan2003 |
  8. | 10jan2003   10jan2003   13jan2003   09jan2003 |
  9. | 13jan2003   13jan2003   14jan2003   10jan2003 |
 10. | 14jan2003   14jan2003          10   13jan2003 |
     +-----------------------------------------------+