Contents: | Main | Chapter | See Also: | Getting Started Manual | Programmer Manual |
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