Page 1 of 1
Totals on date/time fields
Posted: Mon Dec 30, 2002 9:17 am
by Jackie_(Guest)
Hi____I was a good R&R user in the days of Arpeggio and have now ^come back^ to version 10. In the old days I had to convert all my date/time fields to seconds to total them and then convert them back again. Is this still the case in version 10? If not, can someone tell me how to do it now?____Thanks____Jackie
=> RE: Totals on date/time fields
Posted: Mon Dec 30, 2002 12:58 pm
by kfleming
You would need to convert to some format that can be totaled (such as seconds which is a summable numeric) in the manner that you want. For datetime fields, I think that only count, min and max are available.__Kathleen__R&R Support
==> RE: Totals on date/time fields
Posted: Mon Jan 06, 2003 9:16 am
by Jackie_(Guest)
Thanks Kathleen____Can you tell me the function for converting the seconds back into hours, minutes and seconds____Many thanks
===> RE: Totals on date/time fields
Posted: Mon Jan 06, 2003 10:03 am
by Jackie_(Guest)
Never mind - I^ve spotted the STOC function - thanks anyway