VMS Live applications Swiftbase
Home | Live Demo's | Search Engine | Products | Utilities | Government | Hardware | Faqs | Contact | Links

Roger - web developer
 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.