I apologize for the flurry of questions today. As I said, I'm all of "three
days old" with RBase. I'm trying to do a SQL DATEDIFF, but don't find that
in RBase, so I'm getting today's date with .#DATE, and then pulling a Date of
Birth "DOB" from the EMPLOYEE table. I need to see if the given employee is
over 50 years old, so I'm not allowing for month, day and year. I'm used to
DATEDIFF taking care of that for me. How is this calculated in RBase? Do I
need to bust that DATE up into month, day and year and do the math on each
element of that datatype?
IF (.#DATE - (SELECT DOB FROM EMPLOYEE) = 50) THEN
-- Do stuff here
ENDIF
wwwww
( @ @ )
------oOO---(_)---OOo------
Damon J. Gray
Business System Services
Anvil Corporation
(360) 937-0770
oooo0 0oooo
( ) ( )
---------\ (----) /----------
\__) (__/
