Calendar week in Quiz/QTP

Ray Bailey rayb@specialist.co.uk
Fri, 22 Jan 1999 10:29:43 -0000


You've got a small problem here. Cognos use a base Julian date as 01 Jan
1900. If however they used a true base Julian year which is "A year when 01
Jan = Monday and the previous year was a leap year" then this would be very
easy.

I've got some code somewhere but I'm not sure where at the moment. If I find
it I'll let you know.

Ray Bailey
Leicester
England

> -----Original Message-----
> From: owner-powerh-l@sphere.SWAU.EDU
> [mailto:owner-powerh-l@sphere.SWAU.EDU]On Behalf Of Noack, Andreas M.
> Sent: 22 January 1999 10:02
> To: powerh-l@lists.swau.edu
> Subject: Calender week in Quiz/QTP
>
>
> Hello,
>
> maybe somebody can help out with a piece of code. Do anyone out there
> already have codes which does the calculation of WEEK NUMBER from the
> sysdate using QUIZ or QTP? This means for example the sysdate is 19990121,
> and the WEEK NUMBER calculated should be 3. We are currently using PH
> 7.09.E1 on HP3000/Allbase.
>
> Your help or advice on how to perform this calculation is very much
> appreciated.
>
>
> Kind regards
> Andreas Noack
> Information Service Engineer
> Hercules BetzDearborn
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = = = =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.
>

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.