how to make date as a number? 1

[calvi]

I have grouped my data by date, grouped for each 1 week. So the first week: 1-1-2003 contains data for that week, the second week: 8-1-2003 contains data for that week. So the printpreview shows per week as a date. My question: can I change that date into numbers? So week beginning with 1-1-2003 is weeknumber 1, week beginning with 8-1-2003 is weeknumber 2, and so on ...
Is there a solution for this?
Thank you.

 

[Madawc]

In Crystal 8.5, you can use the following command in a formula fields
DatePart ("ww", {your.date})

Mysteriously, there is no entry for 'week number' in the index, you need to go burrowing into command options to find solutions like this.

Madawc Williams
East Anglia, Great Britain