I am using Crystal 8.5 with an Oracle 9.0 database.I am trying to show the "week #" of a date in which a task has been scheduled. I have found multiple ways of doing this but I am struggling with dates that span previous or subsquent years. For example a task scheduled for January 13th 2003 shows up as week 2 but because of my start date, a task scheduled for October 12 2005 shows up as week -11. How can I use my datediff function to look at Jan 1st of the year which the task was scheduled so that the October 12 2005 task shows up as week 41? My formula looks like this:
DateDiff ( 'ww' , #01/01/2006# -1, {WORKORDER.TARGSTARTDATE} , 1 )
DateDiff ( 'ww' , #01/01/2006# -1, {WORKORDER.TARGSTARTDATE} , 1 )