RE: Odd Question

["Greg Novak, Momentum" <gnovak@xxxxxxxxxx>]

Shawn,

As I believe you learned earlier in the week, Info WorkPlace (IWP) is a
report writer tool.  It can help you calculate Vendor performance and it can
do date math.  The examples you were given are good examples of using query
to handle dates - takes 2 or 3 calculations for each date before doing any
math.  IWP has a number of date based functions included that are designed
for date math, allow you to reformat dates for printing or record
selections, etc.

The formatting and layout capabilities of IWP far exceed what query is
(in-)capable of doing.  File linking is done once and retained for use by
many reports.  I could go on, but suggest instead that contact me off-list
or head out to our web site www.jacana.com/mapicsweb for more information.

As you have heard, Momentum is the developer of Mapics Info WorkPlace report
writing and data extraction tool.

Regards,
-Greg

Gregory Novak
Manager North American Technical Services
Momentum Utilities Pty Ltd
(630) 985-1736
gnovak@xxxxxxxxxx
www.jacana.com
 
Making Information Work for your Business
www.intuator.com



-----Original Message-----
From: Shawn Thobe [mailto:ShawnT@xxxxxxxxxxxxxxxxxxxxxxxxxx] 
Sent: Friday, July 23, 2004 9:36 AM
To: MAPICS ERP System Discussion
Subject: RE: Odd Question


THANKS

Shawn Thobe
Supervisor - Information Systems
Fort Recovery Industries Inc.
419-375-4121
 

-----Original Message-----
From: Dan Bale [mailto:dbale@xxxxxxxxxxxxx] 
Sent: Friday, July 23, 2004 10:23 AM
To: MAPICS ERP System Discussion
Subject: RE: Odd Question

> -----Original Message-----
> From: mapics-l-bounces@xxxxxxxxxxxx / Shawn Thobe
> Sent: Friday, July 23, 2004 10:01 AM
>
> Does anybody no how to subtract dates in query.  When I do this it
takes
> the numeric rep of the date and subtracts which works good unless the
> dates are in different months.  Thanks for any help.  I'm trying to
use
> the DATE AND DAYS FUNCTIONS

TRNDT is a numeric cyymmdd date.  In "Define Result Fields":

Field       Expression                         Column Heading        Len
Dec
----------  ---------------------------------  --------------------  ---
-
--
TRANDTW4DY  TRNDT + 19000000                   Transaction             8
0
                                                  Date
                                               yyyy/mm/dd

TRANDT@     digits( TRANDTW4DY )

ZEROTIME    '-00.00.00.000000'

TRANDATETS  TimeStamp( substr(TRANDT@,1,4)||   Transaction
            '-'|| substr(TRANDT@,5,2) ||'-'||      Date
             substr(TRANDT@,7,2) || ZeroTime)   Timestamp

TRANDATE    Date( TRANDATETS )                 Transaction
                                                   Date

The reason I take it all the way to a timestamp, as opposed to just
dropping
it into a date field, is that with a timestamp, you are guaranteed that
the
date will be in yyyy-mm-dd format.  Otherwise, you are subject to
whatever
the job's date format is set to.  TRANDATE is the date data type you can
do
date arithmetic with and use the DAYS function.

hth,
db

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