The Verity engine can parse a variety of date formats. A single date format can include a calendar format plus an optional time format.
If you are using mkvdk, use the
-datefmt
option. If you are developing an application using a Verity API, then you must set the dateInputFormat
member in VdkSessionNewArgRec
. Date Import Format Strings
A variety of constructs can be used to define the import date format string.datefmt
specification, as described in "Numeric Date Formats." If datefmt
is not specified, then the engine first tries to interpret 6- and 8-digit numbers in year-month-day order. If that fails, the engine tries to interpret the numbers in month-day-year order.
Table Conventions
Within the Description
column of the Date Formats table, shown below, the following constructs describe a date format element. These are representational constructs only. That is, elements such as MM DD YYYY
are not actually ever typed in anywhere.
Thus, if you enter the following date as the DATE field value for a document:
252312Z JAN 94
DATE
field value:
Jan 25 94 15:12
02/17/1997 08:55
.The Verity engine understands time formats that have one of the following structures. As in the "Import Date Formats" table, these are representational constructs only. That is, elements such as
hh:mm:ss
are not actually ever typed in anywhere. You would actually see instead 12:34:56
.
hh:mm
hh:mm:ss
hh:mm:ss TIMEOFDAY
hh:mm:ss TIMEOFDAY TIMEZONE
Oct 15 1997 01:33:12 AM PST
By default, dates input into the Documents table are assumed to be in American numeric date format, that is, the month-day-year format (MM-DD-YY). This means that if a user enters a date for a field search query in the same format, the Verity engine can interpret the date and perform the appropriate retrieval. Numeric date formats can be delimited by spaces or slashes in addition to dashes.
If users want to enter date field search criteria in a different format, such as English or European numeric date format, that is, day-month-year or year-month-day, then you must specify to the application which date format to use. If you are using mkvdk, use the
-datefmt
option. If you are developing your own application, then you must set the dateInputFormat
member in VdkSessionNewArgRec
.The
datefmt
syntax options are listed below.
mkvdk -collection collname -bulk -insert filespec -datefmt DMY