Wildcards - Date - BCPro - LIT-12011905 - Server - BCPro Data Server - 4.0

BCPro Data Server

Product
Building Automation Systems > Databases and Data Servers > BCPro Data Server
Document type
User Guide
Document number
LIT-12011905
Version
4.0
Revision date
2020-03-27
For a single date, a wildcard opens a particular field to the full range of possible values for that field. The following table describes the meaning for each type of unspecified wildcard date field.
Table 1. Unspecified Wildcard Date Field Meanings

Unspecified Field

Meaning

Month

Every month

Day of Month

Every day of the month, unless a particular day of the week is specified by the Day of Week field

Year

Every year

Day of Week

Every day of the week, unless a particular day of the month is specified by the Day of Month field

The following table shows some sample wildcard dates and their meanings.
Table 2. Sample Wildcard Date Meanings

Month

Day of Month

Year

Day of Week

Meaning

any

01

any

any

The first day of every month, every year

Mar

05

any

any

March 5 of every year

Mar

05

2010

any

March 5 of 2010

Mar

any

2010

any

Every day in March 2010

any

any

any

any

Every day

any

any

any

Friday

Every Friday

any

any

2010

Friday

Every Friday in 2010

Mar

any

2010

Friday

Every Friday in March of 2010

Mar

12

2010

Friday

Only on Friday, March 12, 2010

Apr

13

any

Monday

Every April 13 that occurs on a Monday

Even

2

2010

any

The second of every even numbered month in 2010: February 2, April 2, June 2, August 2, and so on

any

last

2010

any

The last day of every month in 2010