Wildcards - Date - Metasys - LIT-12011942 - Software Application - ODS Server - 10.1

Metasys Open Data Server Help

Brand
Metasys
Product name
ODS Server
Document type
User Guide
Document number
LIT-12011942
Version
10.1
Revision date
2019-10-14
Language
English

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 or special date field.

Table 1. Unspecified Wildcard Date Field Meanings

Unspecified Field

Meaning

Month

Any = every month

Odd = only odd numbered months (1, 3, 5, 7, 9, 11)

Even = only even numbered months (2, 4, 6, 8, 10, 12)

Day of Month

Any = every day of the month (unless limited by Day of Week entry)

6 or Last = last day of the month

Odd = only odd numbered days of the month (1, 3, 5, 7, 9, 11, and so on)

Even = only even numbered days of the month (2, 4, 6, 8, 10, 12, and so on)

Year

Any = every year

Day of Week

Any = 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 or special 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

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

May

odd

any

any

Every odd numbered day in May

May

even

any

any

Every even numbered day in May