Report Builder - Week# function

Yahoo Archive
1
Thanks so much for that function, Shirley, it worked!!!
2
Does anybody know if a week# function in Report Builder. I found the ones
that return the day in the week, the year and the month, but cannot find one
for the week. I am trying to write a report that our controller can run for
the fiscal period that will show by employee all reg hours and all overtime
hours for the month. Over time hours are al hours over 40 in a week. Any
help on this would be great, thanks,

Sarah
3
Hi Sara,
I received this from Martin Nijdam (Suss Woodcraft) and it works just
great for me.

IIF((Date_rb - DATE("01/01/00")) MODULO 7 = 0, ((Date_ rb -
DATE("01/01/00"))/7,(TRUNCATE((Date_rb - date("01/01/00"))/7,0) + 1))

Shirley Graver
(End User)
Sys Admin
Rubber associates Inc.
Cleveland/Akron

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, March 02, 2001 3:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - Week# function


Does anybody know if a week# function in Report Builder. I found the ones
that return the day in the week, the year and the month, but cannot find
one
for the week. I am trying to write a report that our controller can run
for
the fiscal period that will show by employee all reg hours and all
overtime
hours for the month. Over time hours are al hours over 40 in a week. Any
help on this would be great, thanks,

Sarah

Yahoo! Groups Sponsor

Click Here to Find Software Faster


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]