|
|
 |
 |
|
Date ranges/wildcards
Dates are stored by the index in Century Year Month Day format which makes it useful for a simple wild card date search.
2003MAY* will get you every day in May!
Date ranges are also supported via the date function Date$( StartDate, EndDate, Field ) where you have several options
both for start date and end date.
StartDate can be STARTYEAR, STARTMONTH, STARTWEEK, LASTWEEK, YESTERDAY, DAYS(-180)
EndDate can be ENDMONTH, END YEARD, TODAY, DAYS(-10)
The field specifier allows you to limit your date search to only that field.
|
|