RE: [SYSTEM21] Query Date Program

["Prill, Steve" <sprill@xxxxxxxxxxxxx>]

Hi Mex,

Use the link below, then select the "Query/400 Date Manipulation"
article, which shows you how to calculate the difference between two
dates and a bunch of tricks with dates.
 
http://www.mcpressonline.com/mc/.5bfa4615


Steve


-----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.

This email and any attachment are confidential and may be 
legally privileged.  If you are not the intended recipients,
please notify the author by replying to this email message,
and then delete all copies of the email on the system.  If
you are not the intended recipient, you must not disclose,
distribute, copy, print or use this email in any manner.

Email messages and attachments may contain viruses.  Although
we take precautions to check for viruses, we make no assurances
about the absence of viruses.  We accept no liability and suggest
that you carry out your own virus checks.