Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Weeknum

3 posts in General Discussion Last posting was on 2007-10-10 17:57:40.0Z
Herman Miller Posted on 2007-10-10 16:00:21.0Z
Sender: 851.470cb033.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Weeknum
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <470cf715.1139.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Oct 2007 09:00:21 -0700
X-Trace: forums-1-dub 1192032021 10.22.241.41 (10 Oct 2007 09:00:21 -0700)
X-Original-Trace: 10 Oct 2007 09:00:21 -0700, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6382
Article PK: 2864

Is there a function or easy way to get the weeknum of year
from asa?


Chris Keating (Sybase iAnywhere) Posted on 2007-10-10 17:24:50.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Weeknum
References: <470cf715.1139.1681692777@sybase.com>
In-Reply-To: <470cf715.1139.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-d620.sybase.com
X-Original-NNTP-Posting-Host: keating-d620.sybase.com
Message-ID: <470d0ae2@forums-1-dub>
Date: 10 Oct 2007 10:24:50 -0700
X-Trace: forums-1-dub 1192037090 10.25.98.110 (10 Oct 2007 10:24:50 -0700)
X-Original-Trace: 10 Oct 2007 10:24:50 -0700, keating-d620.sybase.com
Lines: 5
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6387
Article PK: 2867

Look at DateDiff() with WEEK as the date-part.

Herman Miller wrote:
> Is there a function or easy way to get the weeknum of year
> from asa?


Herman Posted on 2007-10-10 17:57:40.0Z
Sender: 851.470cb033.1804289383@sybase.com
From: Herman
Newsgroups: ianywhere.public.general
Subject: Re: Weeknum
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <470d1294.15da.1681692777@sybase.com>
References: <470d0ae2@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Oct 2007 10:57:40 -0700
X-Trace: forums-1-dub 1192039060 10.22.241.41 (10 Oct 2007 10:57:40 -0700)
X-Original-Trace: 10 Oct 2007 10:57:40 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6390
Article PK: 2869

I found it. It was DatePart(cwk

> Look at DateDiff() with WEEK as the date-part.
>
> Herman Miller wrote:
> > Is there a function or easy way to get the weeknum of
> > year from asa?