How can I specify a date in the Macrobond formula language?

You should refer to a date using the date formula.

Date(year, month, day)

It returns the observation number of the specified date. Make sure you input the components of the date in the right order. For example:

Date(2017, 01, 01)