2.5.4 AF12DateInfo

The AF12DateInfo structure specifies the date and time for an advanced AutoFilter comparison.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

year

month

day

hour

minute

second

unused1

reserved1

nodeType

year (2 bytes): An unsigned integer that specifies the year.

month (2 bytes): An unsigned integer that specifies the month. MUST be greater than or equal to 1 and less than or equal to 12.

day (4 bytes): An unsigned integer that specifies the day of the month. MUST be greater than or equal to 1<148> and less than or equal to 31.

hour (2 bytes): An unsigned integer that specifies the hour. MUST be greater than or equal to 0 and less than or equal to 23.

minute (2 bytes): An unsigned integer that specifies the minute. MUST be greater than or equal to 0 and less than or equal to 59.

second (2 bytes): An unsigned integer that specifies the second. MUST be greater than or equal to 0 and less than or equal to 59.

unused1 (2 bytes): Undefined and MUST be ignored.

reserved1 (4 bytes): MUST be zero, and MUST be ignored.

nodeType (4 bytes): An unsigned integer that specifies the date and time to filter on. MUST be one of the values from the table:

Value

Meaning

0x00000000

Filter on year field.

0x00000001

Filter on year and month fields.

0x00000002

Filter on year, month, and day fields.

0x00000003

Filter on year, month, day, and hour fields.

0x00000004

Filter on year, month, day, hour, and minute fields.

0x00000005

Filter on year, month, day, hour, minute, and second fields.