Calender week in Quiz/QTP

[Adrian Compton]

Hi Andreas

Try this, although I havent tested it for all weeks, it should work though

acc filename
def beginyear date = nco(asc(sysdate,8)[1:4] + "0101") ;comment gives begin of current year
def nodays int*4     = days(sysdate) - days(beginyear) + 1
def weeks int*2      = nodays / 7

Regards

Adrian Compton
Virtual Systems Technology
78 Darling Street
Cape Town
8001
Tel : +27 21 4645356
Fax: +27 21 4610801
Cell: +27 82 6590098


>>> "Noack, Andreas M." <Andreas.Noack@BetzDearborn.com> 12:01:40 22 January 1999 >>>
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.