RE: Query Date Program

On V5R2
Date Expression Example: If STARTDATE is a date field and you want   
to add 30 days to it, you can define a date result field BENEDATE    
(the date that benefits are effective) by typing BENEDATE in the     
Field column and typing the expression STARTDATE + 30 DAYS.  When    
the query is run, Query adds the duration of 30 days to the starting 
date to obtain the date that a new employee can begin to receive     
benefits.                                                            

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Mex Davis
Sent: Thursday, August 05, 2004 2:40 PM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Query Date Program

As anyone been successful using Query/400 to find the number of days
between
two dates?
We hear that there is a way but for the life of us, we don't see how you
can.
If you got any hints, we'd like your help.
Thanks.
Mex Davis
IS Manager
Bekum America Corp.


_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.