VA FileMan V. 22.0 Getting Started HTML Manual Banner


 

Main Chapter Getting Started Manual Programmer Manual

VA FileMan Functions


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

 


Reviewed/Updated: March 4, 2007