2.5.4 AF12DateInfo
The AF12DateInfo structure specifies the date and time for an advanced AutoFilter comparison.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
-