RE: Date Math

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

This is a bit difficult.  How do you know what "half a month" is?  Is it
based on the "from" month, or the "to" month?  Half of January is 15.5 days,
while half of February is 14 (or 14.5) days.  How do you know which to use?
However, once you figure out what the days cutoff is, then you might want to
try the following technique:

1. Add the "days cutoff" to the "to" date
2. Subtract the "from" date from the "to" date

I would try this with a WIDE variety of dates before putting it into
practice to make sure it fits with what you expect.

Joe


> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of
> Bruce.Odum@cbs.fiserv.com
> Sent: Thursday, May 31, 2001 3:10 PM
> To: MIDRANGE-L@midrange.com
> Subject: Date Math
>
>
> Question when subtracting two dates using subdur the resulting month will
> always round down.  Is there any function that will allow you to see the
> remaining days to determine if you halfway thru the month so you can round
> the month up?

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---