Re: Year To Date???

[Varsha Das <vdas@MAIL.UCF.EDU>]

Dave:

 

If Julian date is what you are looking for there are a few solutions in the archives of this listserv. Search for "julian" at this URL:

 

 

http://www.sqrug.com/sqr-users/sqrusers_00q2/threads.html

 

One suggestion from those messages was:

—------------------------------------------------------------------------------------------------------------------

• Subject: Re: Julian Date2
• From: Dave Thorburn <thorburn@CONL.NET>
• Date: Wed, 7 Jun 2000 13:14:02 -0700

 

The following will provide you with a 'Julian Date' format
of the current system date:

    Let $Jul-Cur-Date = datetostr($Current-Date, 'YYYYDDD')

You may substitute another date field for $Current-Date

Regards,

Dave
—------------------------------------------------------------------------------------------------------------------

You can trim this if you need just days.

 

HTH,

 

Varsha.

 

 

Date:    Tue, 8 Aug 2000 08:34:44 -0500
From:    "Benzenhafer, Dave" <DBenzenhafer@DEEPWATER.COM>
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