Re: Entering a Date Range in an Array

["Benzenhafer, Dave" <DBenzenhafer@HOUSTON.DEEPWATER.COM>]

What I am trying to do is to specify a date range and populate a field in an
array with the dates sequentially. Would you use a char field for this?

Dave Benzenhafer


-----Original Message-----
From: Bruce Kelling [mailto:Bruce_Kelling@ADVANTECHSOLUTIONS.COM]
Sent: Tuesday, August 13, 2002 2:03 PM
To: SQR-USERS@list.iex.net
Subject: Re: Entering a Date Range in an Array


The easiest way to use dates in an array is with data type = char.  You can
use to_char() function to format data any way you like.  'YYYYMMDD' can
easily be compared to a given date range, also in the same format.

Bruce
-----Original Message-----
From: Benzenhafer, Dave [mailto:DBenzenhafer@HOUSTON.DEEPWATER.COM]
Sent: Tuesday, August 13, 2002 2:45 PM
To: SQR-USERS@list.iex.net
Subject: Entering a Date Range in an Array

Does anyone have an easy way to enter the dates of a date range in an array
date field?

Example Jan 1, 2002 to July 31, 2002
Using SQR 4.3.4

Dave Benzenhafer
EMPAC Custom Report Writer
601-792-4857  601-7146970
dbenzenhafer@houston.deepwater.com