Re: Year To Date???

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

What I'm looking for is The first of the year not to be a hard coded date so
that the report can be used year after year. The problem that I had with
datediff was that it needed actual dates. I didn't seem to work with a
variable in place of a date

-----Original Message-----
From: Rick_Creel@AONCONS.COM [mailto:Rick_Creel@AONCONS.COM]
Sent: Tuesday, August 08, 2000 9:05 AM
To: SQR-USERS@list.iex.net
Subject: Re: Year To Date???


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