Re: Year To Date???

[Rick_Creel@AONCONS.COM]

I am not sure about the summarize function you are seeking.
You can use the DATEDIFF function to determine the number of days.
For example, If you have 2 date variables:

$first_of_year   is set to 01-01-2000
$current_date is set to the date you are working with, like 08-08-2000
then #number_of_days = datediff($current_date,$first_of_year,'day')

Hope this helps





"Benzenhafer, Dave" <DBenzenhafer@DEEPWATER.COM> on 08/08/2000 09:34:44 AM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Rick Creel/IT/Aon Consulting)

Subject:  Year To Date???



Is there a SQR function that will let summarize a cost field Year To Date or
Month To Date. I am also looking for a way to count the days from the first
of a year to a date in that year.

Any help will be appreciated

Dave Benzenhafer
Transocean Sedco Forex
dbenzenhafer@deepwater.com