Download Fileman 22.2 Advanced User Manual

Chapter 7: Fileman Functions
Example:
Fileman 22.2 Advanced User Manual
NUMYEAR4(DATE OF BIRTH) => 1949 [DATE OF
BIRTH = March 7, 1949]
RANGEDATE
Format:
RANGEDATE(datexp1,datexp2,datexp3,datexp4)
Parameters:
datexp1 is a date valued expression beginning the first
range of dates.
datexp2 is a date valued expression ending the first range
of dates.
datexp3 is a date valued expression beginning the second
range of dates.
datexp4 is a date valued expression ending the second
range of dates.
Use:
This function returns the number of days that the two
ranges of dates overlap.
Example:
RANGEDATE(DATE OF BIRTH,NOW,20 JUL 1981,20
JUL 1982) => 366
TIME
Format:
TIME(datexp)
Parameters:
datexp is an expression with a date/time value.
Use:
This function returns time from datexp in 12 hour format
with AM/PM.
Example:
TIME(NOW) => 1:15 PM
TODAY
Format:
TODAY
Parameters:
(none)
March 2013
95