RE: Query........Manipulating TimeFields

[Bill Erhardt <ERHARDT@xxxxxxxxxxxxx>]

If you select F1 on the Define Results Panel, you will see definitions on
how to calculate the difference between dates and time.  The problem, as I
understand it, is converting your date and time fields into time stamps.
I've built date data type fields by using the date function for example:
Field              Expression
X                    Digits(Date60) - Converts a 6,0 field to character data
Date
Date(substr(x,1,2)||'/'||Substr(x,3,2)||'/'||substr(x,5,2))
This converts the value of field date60 into a date data type.    Date60
must contain a valid date value.

You could try building the same type of thing using the TIME, or TimeStamp
functions.
Bill Erhardt
Baldwin Hardware 

> -----Original Message-----
> From: sgt.walsh@icdc.com [SMTP:sgt.walsh@icdc.com]
> Sent: Friday, July 14, 2000 2:05 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: Query........Manipulating TimeFields
> 
> Yes, I will be calculating elapsed times across date boundaries.
> I will be doing this in Query 400.
> 
> Sergeant John P. Walsh
> Haverford Township Police Department
> 1010 Darby Road
> Havertown, PA 19083
> Voice   610.853.1298 ext 212
> Fax      610.853.9210
> sgt_walsh@icdc.com << File: ATT04687.txt >>  << File: Message Body >> 


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