Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DatePart function returns incorrect week number
Kai, Thanks for the feedback on DatePart problem. I know that in oracle pl/sql I can use TO_CHAR(ACT.STARTDATUM , 'IW')) to get the correct result i.e. week number 1. I think this uses ISO and 'IW' means 'international week'. I'll give your ideas a go. Cheers.- consultfm
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
DatePart function returns incorrect week number
Hi, I'm having a problem getting the correct week number for the date 31st December 2001 in Crystal Reports 8.0. Using Monday as first day of the week and the week containing Jan 1st as first week of the year, my formula: DatePart("ww", #December 31, 2001#, crMonday, crFirstJan1)...- consultfm
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
