AddDateRestriction

AddDateRestriction adds a date restriction expression to the open RMS file

Syntax

Sub AddDateRestriction(rmsHandle As Integer, fldname As String, rmsop As Integer, datestr As String, datefmt As String)

Parameters

rmsHandle

RMS file handle

fldname

Field name

rmsop

Restriction operator.  Supported values:

EQ            equal

                    NE          not equal

                    LE          less than and equal

                    LT          less than

                    GE          greater than and equal

                    GT          greater than

datestr

Date value as string

datefmt

Date format.  Supported date formats:

MM/DD/YY, MM.DD.YY, MMDDYY, MM-DD-YY, MM/DD/YYYY,

          MM.DD.YYYY, MMDDYYYY, MM-DD-YYYY, DD/MON/YY,

          DD.MON.YY, DDMONYY, DD-MON-YY, DD/MON/YYYY,

          DD.MON.YYYY, DD-MON-YYYY

Return Values

No return value

Remarks

Call AddDateRestriction to add a date field restriction expression to the open RMS file before calling FirstRestrictionRecordFirstRestrictionRecord to search records.  Always make sure the field type is CBDATETYPE for field with name fldname.

See Also

AddStringRestrictionAddStringRestriction, AddCharRestrictionAddCharRestriction, AddIntegerRestrictionAddIntegerRestriction,

AddLongRestrictionAddLongRestriction, AddRealRestrictionAddRealRestriction, AddDateRestrictionAddDateRestriction,

AddTimeRestrictionAddTimeRestriction, AddBooleanRestrictionAddBooleanRestriction, GetFieldTypeGetFieldType,

GetFieldTypebyNameGetFieldTypebyName, AddStringRestriction