Download User Reference Guide - MSC Fileman 22.2 Documentation

MSC Fileman 22.2 User Reference Guide
Part 4: Computing Data
Date/Time Functions
BETWEEN
Format:
BETWEEN(d1,d2,d3)
Parameters:
d1, d2, and d3 are dates or date expressions:
d1 is the date being tested.
d2 is one limit for the test.
d3 is the other limit for the test.
Use:
This Boolean function determines if d1 is within the
limits defined by d2 and d3. If d1 is within this range, a
value of 1 (true) is returned; otherwise, 0 (false) is
returned. If d1 equals d2 or d3, 1 (true) is returned.
Examples:
Select OPTION: SEARCH FILE ENTRIES
OUTPUT FROM WHAT FILE: BUILD// <Enter>
-A- SEARCH FOR BUILD FIELD: BETWEEN(DATE
DISTRIBUTED,1JAN2000,1JAN2001)
-B- SEARCH FOR BUILD FIELD:
IF: A// <Enter> BETWEEN(DATE
DISTRIBUTED,1JAN2000,1JAN2001)
DATE
Format:
DATE(datexp)
Parameters:
datexp is an expression with a date/time value.
Use:
This date function returns the date portion of a date/time
expression.
Example:
DATE(NOW) => AUG 21,1991
REF: For tips on displaying date-valued elements such as this
function in computed expressions (e.g., printing), see the "Data Types in
Computed Expressions" topic in the "Computed Expressions" section.
166
January 2015